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:
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 !!
Previous Comments:
------------------------------------------------------------------------
[2005-11-16 21:21:37] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
Please try new OCI8 from PECL.
Windows DLLs can be found here: http://pecl4win.php.net
------------------------------------------------------------------------
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
