ID: 44206 Updated by: [EMAIL PROTECTED] Reported By: christopher dot jones at oracle dot com -Status: Open +Status: Closed Bug Type: OCI8 related Operating System: n/a PHP Version: 5.2.5 New Comment:
This bug has been fixed in CVS. Snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at http://snaps.php.net/. Thank you for the report, and for helping us make PHP better. +------------------------------ | Fix has been merged to 5.2.6, 5.3 and 6. | Thanks go to Haneef. +------------------------------ Previous Comments: ------------------------------------------------------------------------ [2008-02-21 19:29:30] christopher dot jones at oracle dot com Description: ------------ When more than one REF CURSOR is returned in a query, ORA-1000 occurs after some iterations. Haneef investigated and says: "The refcount of the parent statement is incremented by the ref cursors in php_oci_define_callback and is not decremented. The incrementing is necessary as the parent statement needs to be around while fetching the data from the ref cursor. The fix is to decrement the refcount of the parent statement before ref cursor is freed." The fix is being tested. Reproduce code: --------------- <?php $c = oci_connect('hr', 'hrpwd', '//localhost/XE'); for ($x = 0; $x < 400; $x++) { // more than one CURSOR column causes the problem. $sql = "select cursor(select $x from dual) a, cursor(select $x from dual) b from dual"; $sth = oci_parse($c, $sql); $r = oci_execute($sth); if (!$r) { echo "Exiting $x\n"; exit; } while ($row = oci_fetch_array($sth, OCI_ASSOC)) { if ($row) { foreach ($row as $k => $v) { if (is_resource($v) && get_resource_type($v) == "oci8 statement") { oci_execute($v); oci_fetch_all($v, $row[$k], 0, -1, OCI_ASSOC); oci_free_statement($v); } } } echo $x, "\n"; } oci_free_statement($sth); } print "Completed $x\n"; oci_close($c); ?> Expected result: ---------------- ... 398 399 Completed 400 Actual result: -------------- ... 295 296 PHP Warning: oci_execute(): ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded in test.php on line 10 Exiting 297 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=44206&edit=1
