#46565 [NEW]: oci_fatch_all return ORA-01002

From: james_blond at hipernet dot brda dot net Operating system: WINXP/AIX PHP version: 5.2.6 PHP Bug Type: OCI8 related Bug description: oci_fatch_all return ORA-01002 Description: ------------ function oci_fetch_all on second use return error ORA-01002: fetch out of sequence. Reproduce code: --------------- $dbstr = "(DESCRIPTION = (ADDRESS = PROTOCOL = TCP (HOST = host)(PORT = 1521))(CONNECT_DATA = (SID = sid)))"; $c = oci_connect("user","pass",$dbstr,"UTF8"); $SQL = "SELECT * FROM table "; // table have more then 100 rec $s = oci_parse($c,$SQL); oci_execute($s,OCI_COMMIT_ON_SUCCESS); oci_fetch_all($s,$Row,0,10, OCI_NUM); print_r($Row); oci_fetch_all($s,$Row,10,10, OCI_NUM);// here return error ORA-01002 print_r($Row); Expected result: ---------------- printed array $Row Actual result: -------------- array $Row is printed only on first time on second $Row is empty , oci_fetch_all -> return error ORA-01002: fetch out of sequence. -- Edit bug report at http://bugs.php.net/?id=46565&edit=1 -- Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=46565&r=trysnapshot52 Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=46565&r=trysnapshot53 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=46565&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=46565&r=fixedcvs Fixed in CVS and need be documented: http://bugs.php.net/fix.php?id=46565&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=46565&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=46565&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=46565&r=needscript Try newer version: http://bugs.php.net/fix.php?id=46565&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=46565&r=support Expected behavior: http://bugs.php.net/fix.php?id=46565&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=46565&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=46565&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=46565&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=46565&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=46565&r=dst IIS Stability: http://bugs.php.net/fix.php?id=46565&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=46565&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=46565&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=46565&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=46565&r=mysqlcfg