OCIBindByName problem

Anon

Whenever I use OCIBindByName I get
Warning: OCIStmtExecute: ORA-03113: end-of-file on communication channel in /usr/local/apache/htdocs/regist.php3 on line 45 My code is as:

42>$conn=OCILogon(\"usr\",\"pwd\",\"myhost\")
43>$stmt=ociparse($conn,\"select empname from emp_master where empcode=:code\");
44>OCIBindByName($stmt,\":code\",&$e_code,9);
45>OCIExecute($stmt);

if I comment out line 45 & put some value instead of :code I get the desired result.
Any help in this regard will be greatly appreceited.

thks.

Anon

Which version of PHP are you using ?

I had this pb in PHP4-RC1 and this was corrected in PHP production release.

Watch the logs of your Oracle server, the requested server must have died and this could cause your error.

Anon

I am using PHP3.0.16 & Oracle 8.1.5.

BTW where to watch these oracle logs.

thks.

Anon

look for the parameters background_dump_dest
and core_dump_dest in the v$parameter table.
'?' stands for $ORACLE_HOME.

By default this parameters are respectively set to:
?/rdbms/log
?/dbs/dbs

I didn't use v3.0.x for a while and I'm not of any help for the moment. Sorry. but I'm still looking for any pb related to this version and OCI8.

As said Tim Perdue in his today's article , if possible, consider upgrading to PHP4. It's a great upgrade for a little effort.