#31693 [Com]: "ORA-01001: invalid cursor" after invoking oci-fetch-all function

ID: 31693 Comment by: sgattas at fibertel dot com dot ar Reported By: Tomasz dot Fryc at bph dot pl Status: No Feedback Bug Type: OCI8 related Operating System: Windows 2003 Server PHP Version: 5.0.3 New Comment: Sorry to interrupt. This error happens with IIS running ISAPI. No matter what type of conection (ocilogin, oci_new_connect, etc) function you use you get the error while data is being retriving from a ref cursor in an oracle pck or prc. Invalid cursors everywhere. As far as I tested (I can confirm this): you have two different sessions: session 1 executes the prc o pck, a few moments later session 2 does the same and then session 1 gets the error invalid cursor, losing all data untill the moment session 2 started. Seems session 2 steals the conection while session 1 is still fetching. Guess this error defeates any use of ref cursors when you have more than one user in your site (and we have lots of users). Please help!!!!!!!!! Previous Comments: ------------------------------------------------------------------------ [2005-07-08 01:00:04] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2005-06-30 18:54:06] wez@php.net If you could provide the requested feedback by tomorrow, I'll be able to do more to help you. ------------------------------------------------------------------------ [2005-06-27 21:06:40] wez@php.net Are you running ISAPI PHP under IIS? ------------------------------------------------------------------------ [2005-04-04 19:51:25] terry dot greenlaw at logicalshift dot com I am seeing the same error while using oci_fetch_array(). I am using oci_new_connect('u','pw','db') in my main script. The script uses oci_fetch_array() to loop through items. Each item has an image tag which calls another script to fetch a jpg from a blob. <img src="view_image.php?id=n">. The view_image.php script also does an oci_new_connect() using the same credentials, fetches the jpeg from the blob using oci_fetch_array, outputs the jpeg data stream, and exits. I am getting sporatic ora-1001 errors. However, if I place a return() in the view_image.php code before the oci_new_connect(), the main script does not generate any ora-1001 errors. I've tried numerous combinations of freeing oracle resources in both scripts, as well as switching the view_image script to use oci_connect(), but the problem persists. ------------------------------------------------------------------------ [2005-03-08 01:00:30] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/31693 -- Edit this bug report at http://bugs.php.net/?id=31693&edit=1