ID: 31693
Comment by: fixit at bugs dot com
Reported By: Tomasz dot Fryc at bph dot pl
Status: Open
Bug Type: OCI8 related
Operating System: Windows 2003 Server
PHP Version: 5.0.3
New Comment:
This seems to happens irregularly for me.
Previous Comments:
------------------------------------------------------------------------
[2005-01-25 21:49:19] Tomasz dot Fryc at bph dot pl
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 this bug report at http://bugs.php.net/?id=31693&edit=1
