SCORM Last completed attempt causes Error reading from database (ORACLE)

Steps
1) Add a SCORM package
2) Set in Attempts management “Last completed attempt”
3) Push Save and Display
Using Oracle you’ll get “Error reading from database”.
This error is due to this query in mod/scorm/locallib.php (function scorm_get_last_completed_attempt):
$sql = "SELECT MAX(attempt)
FROM

WHERE userid = ? AND scormid = ?
AND (value='completed' OR value='passed')";

because value is a CLOB.
The solution is to correct the query in this way

• AND (value='completed' OR value='passed')";
  + AND (".$DB->sql_order_by_text('value')."='completed' OR ".$DB->sql_order_by_text('value')."='passed')";