Oracle cannot cope withan IN operator with more than 1000 conditions in it

Problem with query with In operator with more than 1000 condition in it (error ORA-01795: maximum number of expressions in a list is 1000)

Proposed solution:
an hack in the lib/dml/oci_nativa_moodle_database.php
Due to the fact we are working at the library level, it's not possible to use a subquery instead of the "long" list of parameters. We adopted the other suggested approach: to parse the sql code for the IN operator with more than 1000 conditions and to rewrite it as a series of IN operators connected through the OR condition (suggestion from http://forums.oracle.com/forums/thread.jspa?threadID=233143)

The hack is the following:
<

/lib/dml/oci_native_moodle_database.php> : 1040 //added some lines to use the defined method "ORA01795_hack" on the SQL query
//LkM79 for ISP, 2010-04-03
//var_dump(method_exists($this,'ORA01795_hack'));
$sql=$this->ORA01795_hack($sql);

<

/lib/dml/oci_native_moodle_database.php> : 981 //added some lines (a function) to split every IN clause with more than 1000 conditions in a OR combination of many shorter IN lists
/**

• Driver specific hack for introducing a sort of support for IN list with more than 1000 condition
• split the IN list with more than 1000 co0nditions in many lists, connected through an OR operator
• @return string
• LkM79 for ISP, 2010-04-03
  */
  public function ORA01795_hack($sql){
  //var_dump($sql);
  //var_dump(stripos($sql,"IN (?,"));
  //var_dump(explode("?,",$sql));

$start=stripos($sql," IN (?,");
if($start>1) {
$end=stripos(substr($sql,$start),"?)")+2;
//var_dump($end);
$in_list=substr($sql, $start,$end);
//var_dump($in_list);
$n=explode("?,",$in_list);
//var_dump($n);
$slices=(int)((count($n))/1000)+1;
//var_dump($slices);
$step=(int)((count($n))/$slices);
//var_dump($step);
if($slices>1){
$sql_i=substr($sql,0,$start);
$field=strrchr($sql_i, " ");
$sql_i=substr($sql_i,0,-strlen($field));
$sql_e=substr($sql,$start+$end);
$sql_in=' (';
for($i=0;$i<$slices;$i++){
$sql_in.=" $field IN (";
if($i<($slices -1)){
for($t=0;$t<($step-1);$t++)

$sql_in.='?))';
}
}
$sql=$sql_i.$sql_in.$sql_e;
}
}
//var_dump($sql);
return $sql;
}

}

Attached, the modified version of the oci_native_moodle_database.php file