Oracle * OCI functions - error with OCIExecute

[jdmartin74]

I have just installed Oracle on a LINUX box. The database is on a Windows 2000 server. I would like a PHP script to connect to this. I've created a script based on the manual which I understand should work. I get an error however.

I just wondered if anyone with any experiencing of using the OCI8 commands could see a problem.

The error is:

Warning: ociexecute(): OCIStmtExecute: Error while trying to retrieve text for error ORA-03106 in /home/httpd/html/oracle1.php on line 18

My script is: (I've removed the password and username for this post)

<?php

$username = &quot;xxxxxx&quot;;
$passwd = &quot;xxxxxx&quot;;
$db=&quot;(DESCRIPTION=
          (ADDRESS_LIST=
            (ADDRESS=(PROTOCOL=TCP)
              (HOST=172.16.2.12)(PORT=1521)
            )
          )
           (CONNECT_DATA=(SERVICE_NAME=ORCL))
     )&quot;;

$conn = OCILogon($username,$passwd,$db);

$stmt = ociparse($conn,&quot;select code from items&quot;);

ociexecute($stmt);

while (ocifetch($stmt)) {
    echo ociresult($stmt,&quot;code&quot;).&quot;<br>&quot;;

}

?>

 

[jdmartin74]

To follow: although I obviously have a further problem as my server can't display the error message, I believe the error to be 'fatal two-task communication protocol error'.