|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2008-02-26 00:24 UTC] sixd@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Thu Oct 30 22:00:01 2025 UTC |
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