#31693 [Fbk->Csd]: "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 +Status: Closed Bug Type: OCI8 related Operating System: Windows 2003 Server PHP Version: 5.0.3 New Comment: Fixed -> closed. Previous Comments: ------------------------------------------------------------------------ [2005-11-16 22:54:24] sgattas at fibertel dot com dot ar The php page is similar as <? session_start(); $conn=OCILogon("test", "test", "db"); $mout=OCINewCursor($conn); $s=OCIParse($conn, "begin usr.usr_login(:b1,:b2,:b3,:b4,:b5,:b6,:b7); end;"); OCIBindByName($s, ":b1", &$usr1 ,-1); OCIBindByName($s, ":b2", &$pas ,-1); OCIBindByName($s, ":b3", &$lang ,-1); OCIBindByName($s, ":b4", $sess ,38); OCIBindByName($s, ":b5", $mout ,-1, OCI_B_CURSOR); OCIBindByName($s, ":b6", $out ,600); OCIBindByName($s, ":b7", $nus ,200); OCIExecute($s, OCI_DEFAULT); OCIExecute($mout); ?> And the oracle stored procedure: procedure usr_login (p_user in usr_payroll.pay_usr%type, p_pass in usr_payroll.pay_pass%type, p_lang in usr_language.lan_id%type, p_sess out usr_session.ses_id%type, p_tree out typ_access_cur, p_msge out varchar2, p_name out varchar2) end usr_login; The same page and stored procedure working good before replace de php_oci8.dll Thank a lot again !! ------------------------------------------------------------------------ [2005-11-16 21:21:37] tony2001@php.net http://pecl4win.php.net/ext.php/php_oci8.dll - choose the one that fits your PHP version. ------------------------------------------------------------------------ [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! ------------------------------------------------------------------------ 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