|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #44206 Cursor leak with REF CURSORS
Submitted: 2008-02-21 19:29 UTC Modified: 2008-02-26 00:24 UTC
From: christopher dot jones at oracle dot com Assigned:
Status: Closed Package: OCI8 related
PHP Version: 5.2.5 OS: n/a
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
Solve the problem:
11 + 44 = ?
Subscribe to this entry?

 [2008-02-21 19:29 UTC] christopher dot jones at oracle dot com
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:
$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_fetch_all($v, $row[$k], 0, -1, OCI_ASSOC);
        echo $x, "\n";
print "Completed $x\n";

Expected result:
Completed 400

Actual result:
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


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2008-02-26 00:24 UTC]
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
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.

PHP Copyright © 2001-2022 The PHP Group
All rights reserved.
Last updated: Tue Dec 06 04:05:54 2022 UTC