3 * @version V4.22 15 Apr 2004 (c) 2000-2004 John Lim (jlim@natsoft.com.my). All rights reserved.
4 * Released under both BSD license and Lesser GPL library license.
5 * Whenever there is any discrepancy between the two licenses,
6 * the BSD license will take precedence.
8 * Set tabs to 4 for best viewing.
10 * Latest version is available at http://php.weblogs.com
15 include_once(ADODB_DIR . '/drivers/adodb-oci8.inc.php');
17 class ADODB_oci805 extends ADODB_oci8
19 var $databaseType = "oci805";
20 var $connectSID = true;
22 function ADODB_oci805()
27 function &SelectLimit($sql, $nrows = -1, $offset = -1, $inputarr = false, $secs2cache = 0)
29 // seems that oracle only supports 1 hint comment in 8i
30 if (strpos($sql, '/*+') !== false)
31 $sql = str_replace('/*+ ', '/*+FIRST_ROWS ', $sql);
33 $sql = preg_replace('/^[ \t\n]*select/i', 'SELECT /*+FIRST_ROWS*/', $sql);
36 The following is only available from 8.1.5 because order by in inline views not
37 available before then...
38 http://www.jlcomp.demon.co.uk/faq/top_sql.html
40 if ($offset > 0) $nrows += $offset;
41 $sql = "select * from ($sql) where rownum <= $nrows";
46 return ADOConnection::SelectLimit($sql, $nrows, $offset, $inputarr, $secs2cache);
50 class ADORecordset_oci805 extends ADORecordset_oci8
52 var $databaseType = "oci805";
54 function ADORecordset_oci805($id, $mode = false)
56 $this->ADORecordset_oci8($id, $mode);