From: Tomasz dot Fryc at bph dot pl
Operating system: Windows 2003 Server
PHP version: 5.0.3
PHP Bug Type: Oracle related
Bug description: "ORA-01001: invalid cursor" after invoking oci-fetch-all
function
Description:
------------
Database (Oracle 9.2.0.5.0 on HP-UX 11.11) connection is opened with
oci_new_connect function. A statment is prepared with oci_parse and a
cursor is created with oci_new_cursor. After binding the statement to the
cursor (oci_bind_by_name), the statement and the cursor are executed
(oci_execute). The problem occures while invoking oci_fetch_all function,
which sometimes doesn't give expected number of rows (not all of the rows
are fetched) and causes "ORA-01001: invalid cursor" warning.
Reproduce code:
---------------
$sql="begin EXM.MY_PKG.getrows('param1','param2'); end;"
$conn=oci_new_connect("somebody","something")
$curs=oci_new_cursor($conn)
$stmt=oci_parse($conn,$sql)
oci_bind_by_name($stmt,"data",$curs,-1,OCI_B_CURSOR)
oci_execute($stmt,OCI_DEFAULT)
oci_execute($curs,OCI_DEFAULT)
$nrows=oci_fetch_all($curs,$results)
oci_free_statement($curs)
oci_free_statement($curs)
Expected result:
----------------
Every function is correctly executed except oci_fetch_all, which sometimes
doesn't give all of the rows.
--
Edit bug report at http://bugs.php.net/?id=31693&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=31693&r=trysnapshot4
Try a CVS snapshot (php5.0):
http://bugs.php.net/fix.php?id=31693&r=trysnapshot50
Try a CVS snapshot (php5.1):
http://bugs.php.net/fix.php?id=31693&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=31693&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=31693&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=31693&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=31693&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=31693&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=31693&r=support
Expected behavior: http://bugs.php.net/fix.php?id=31693&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=31693&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=31693&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=31693&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=31693&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=31693&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=31693&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=31693&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=31693&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=31693&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=31693&r=mysqlcfg
