On Wed, Mar 06, 2002 at 10:59:33PM +0500, Mohammad Saad wrote:
> Hello
> I have PHP4.10 on solaris with oci8 support. everything seems to work
> well. Oracle support is working fine. but I am getting an error when I
> am trying OCIBindByName to bind a variable to an out variable of a
> stored procedure.
> I have checked this code on php4.10 on windows 2k with same database
> and it works well. I get the value of the out variable in my binded
> variable of PHP script.
> .Only PHP on solaris is giving me the error, any ideas why? here is the
> code and the error
>
> $getcardvalidity = "begin customer.scratch_check
> ('$serial','$code1','$code2',:amount);end;";
> $cardstmt = OCIParse($conn,$getcardvalidity);
> OCIBindByName ( $cardstmt, ":amount", &$amount,4);
> OCIExecute($cardstmt,OCI_DEFAULT);
>
> Warning: OCIStmtExecute: Error while trying to retrieve text for error
> ORA-03113
03113, 00000, "end-of-file on communication channel"
// *Cause:
// *Action:
your db-connection died.
please try to connect from your windows box to this db to
see if the problem is PHP or oracle related!
tc
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
