#43449 [NEW]: Segmentation Fault when calling PL/SQL-function wich returns ref cursor

[michael dot virnstein at brodos dot de]

From:             michael dot virnstein at brodos dot de
Operating system: Linux
PHP version:      5.2.5
PHP Bug Type:     OCI8 related
Bug description:  Segmentation Fault when calling PL/SQL-function wich returns 
ref cursor

Description:
------------
PHP: since 5.2.4
Apache: 2.2.6
Oracle DB: 10.2.0.3.0
Oracle-Client: 10.2.0.3
OS: Linux

When i'm calling a PL/SQL-function, which returns a ref cursor, more than
once, php segfaults. When i call the PL/SQL-function only once, everything
works. 
 
The bug is present since PHP 5.2.4, which introduced OCI 1.2.4

Create the following Oracle-package:

create or replace package testpackage 
is
  type cursortype is ref Cursor;
  
  function testcursor return cursortype;

end testpackage;
/

create or replace package body testpackage 
is
   function testcursor return cursortype
   is
      retCursor cursorType;
   begin
      Open retCursor For 'select * from dual';
      return retCursor;
   end;
end testpackage;
/

Reproduce code:
---------------
<?php
$conn =  ocilogon('user', 'pass', 'db');

for ($i = 0; $i < 2; $i++)
{
    var_dump(getCur($conn));
}

function getCur($conn)
{   
    
    $cur = OCINewCursor($conn);
    $stmt = ociparse($conn, 'begin :cur := testpackage.testcursor;
end;');
    ocibindbyname($stmt, ':cur', $cur, -1, OCI_B_CURSOR);
    ociexecute($stmt, OCI_DEFAULT); // <-- segfault 
    ociexecute($cur, OCI_DEFAULT);
    
    $ret = array();
    
    while (ocifetchinto($cur, $row, OCI_ASSOC))
        $ret[] = $row;
    
    ocifreestatement($cur);
    ocifreestatement($stmt);
    return $ret;
}

?>

Expected result:
----------------
display var_dump result

Actual result:
--------------
apache segmentation fault

-- 
Edit bug report at http://bugs.php.net/?id=43449&edit=1
-- 
Try a CVS snapshot (PHP 4.4): 
http://bugs.php.net/fix.php?id=43449&r=trysnapshot44
Try a CVS snapshot (PHP 5.2): 
http://bugs.php.net/fix.php?id=43449&r=trysnapshot52
Try a CVS snapshot (PHP 5.3): 
http://bugs.php.net/fix.php?id=43449&r=trysnapshot53
Try a CVS snapshot (PHP 6.0): 
http://bugs.php.net/fix.php?id=43449&r=trysnapshot60
Fixed in CVS:                 http://bugs.php.net/fix.php?id=43449&r=fixedcvs
Fixed in release:             
http://bugs.php.net/fix.php?id=43449&r=alreadyfixed
Need backtrace:               http://bugs.php.net/fix.php?id=43449&r=needtrace
Need Reproduce Script:        http://bugs.php.net/fix.php?id=43449&r=needscript
Try newer version:            http://bugs.php.net/fix.php?id=43449&r=oldversion
Not developer issue:          http://bugs.php.net/fix.php?id=43449&r=support
Expected behavior:            http://bugs.php.net/fix.php?id=43449&r=notwrong
Not enough info:              
http://bugs.php.net/fix.php?id=43449&r=notenoughinfo
Submitted twice:              
http://bugs.php.net/fix.php?id=43449&r=submittedtwice
register_globals:             http://bugs.php.net/fix.php?id=43449&r=globals
PHP 3 support discontinued:   http://bugs.php.net/fix.php?id=43449&r=php3
Daylight Savings:             http://bugs.php.net/fix.php?id=43449&r=dst
IIS Stability:                http://bugs.php.net/fix.php?id=43449&r=isapi
Install GNU Sed:              http://bugs.php.net/fix.php?id=43449&r=gnused
Floating point limitations:   http://bugs.php.net/fix.php?id=43449&r=float
No Zend Extensions:           http://bugs.php.net/fix.php?id=43449&r=nozend
MySQL Configuration Error:    http://bugs.php.net/fix.php?id=43449&r=mysqlcfg