#31693 [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: Feedback Bug Type: OCI8 related Operating System: Windows 2003 Server PHP Version: 5.0.3 New Comment: http://pecl4win.php.net/ext.php/php_oci8.dll - choose the one that fits your PHP version. Previous Comments: ------------------------------------------------------------------------ [2005-11-16 21:13:58] popo_x at hotmail dot com i have installed php 5.0.4 and i dont find these version of php_oci8.dll. Which one i must install ? ------------------------------------------------------------------------ [2005-11-16 19:16:53] tony2001@php.net Check why the connection resource is NULL. I can't say anything without looking at your code. ------------------------------------------------------------------------ [2005-11-16 19:11:07] sgattas at fibertel dot com dot ar 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! ------------------------------------------------------------------------ [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!!!!!!!!! ------------------------------------------------------------------------ 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