Error executing cli migrate.php when database is Oracle

[jaume77]

In the /migratehvp2h5p/cli/migrate.php file a sql query with "LIMIT" is used.

In DB Oracle, it doesn't work.

I think that the Moodle function $DB->get_records_sql is already prepared to be able to define a limit, so that the code could perhaps be changed from:

if (!empty($limit)) {
    $sql .= " LIMIT " . $limit;
}

$activities = $DB->get_records_sql($sql, $params);

to

$activities = $DB->get_records_sql($sql, $params, 0, $limit);

(I think $limit is instantiated at this point)

Greetings