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

ID: 31693 Updated by: tony2001@php.net Reported By: Tomasz dot Fryc at bph dot pl -Status: No Feedback +Status: Feedback Bug Type: OCI8 related Operating System: Windows 2003 Server PHP Version: 5.0.3 New Comment: Please try new OCI8 from PECL. Windows DLLs can be found here: http://pecl4win.php.net Previous Comments: ------------------------------------------------------------------------ [2005-11-16 14:48:24] sgattas at fibertel dot com dot ar 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!!!!!!!!! ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ 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