#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: Feedback Bug Type: OCI8 related Operating System: Windows 2003 Server PHP Version: 5.0.3 New Comment: Thanks a lot for the followup. I downloaded the extension. However, I never used this extensions and now I get an error: "PHP Warning: ocibindbyname() expects parameter 1 to be resource, null given in ...", happens in every oci8 instruction I ran. Can you suggest what can be wrong? Thanks a lot for your time! Previous Comments: ------------------------------------------------------------------------ [2005-11-16 15:27:40] tony2001@php.net Please try new OCI8 from PECL. Windows DLLs can be found here: http://pecl4win.php.net ------------------------------------------------------------------------ [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? ------------------------------------------------------------------------ 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