Problem ORA-03106: fatal two-task communication prot ocol error with varchar2 column

I've not found examples for OCIResult: could you try OCIDefineByName whether it runs? I discovered now about OCIResult.Sorry. Ciao Roberto > -----Messaggio originale----- > Da: Roberto Sartor [mailto:roberto@mionetto.it] > Inviato: martedì 5 dicembre 2000 17.43 > A: 'Tim Parkin'; 'halim'; php-db@lists.php.net > Oggetto: [PHP-DB] R: [PHP-DB] Problem ORA-03106: fatal two-task > communication prot ocol error with varchar2 column > > > First:I suggest making SQL statement all in uppercase, > against Oracle:so > manual says. > Second: You miss OCIDefineByName, after OCIParse. > > This script from a famous manual: > > Esempio 1. OCIDefineByName > > <?php > /* OCIDefineByPos example thies@thieso.net (980219) */ > > $conn = OCILogon("scott","tiger"); > > $stmt = OCIParse($conn,"select empno, ename from emp"); > > /* the define MUST be done BEFORE ociexecute! */ > > OCIDefineByName($stmt,"EMPNO",&$empno); > OCIDefineByName($stmt,"ENAME",&$ename); > > OCIExecute($stmt); > > while (OCIFetch($stmt)) { > echo "empno:".$empno."\n"; > echo "ename:".$ename."\n"; > } > > OCIFreeStatement($stmt); > OCILogoff($conn); > ?> > > > > Ciao > Roberto > > > > -----Messaggio originale----- > > Da: Tim Parkin [mailto:Tim.Parkin@didio.com] > > Inviato: martedì 5 dicembre 2000 17.22 > > A: 'halim'; php-db@lists.php.net > > Oggetto: RE: [PHP-DB] Problem ORA-03106: fatal two-task > communication > > prot ocol error with varchar2 column > > > > > > never had this problem ... I don't use empno or ename though, I use > > media_title and media_publisher > > > > -----Original Message----- > > From: halim [mailto:halim@inf.its-sby.edu] > > Sent: Tuesday, December 05, 2000 08:49 > > To: php-db@lists.php.net > > Subject: [PHP-DB] Problem ORA-03106: fatal two-task communication > > protocol error with varchar2 column > > > > > > This page works if I omitted ename from select statement. > > Does anybody have the similar problem ? > > I running RedHat 7.0 Mandrake with Oracle 8.1.5 Client > > connecting to Oracle > > 8.1.6 Server on NT, Apache 1.3.12, Php 4.0.3pl. > > > > <? > > print "<HTML><TITLE>". time() ."</TITLE>"; > > $conn = OCILogon("scott","tiger","rpl.world") or > > die("Could not make > > connection"); > > $statement = OCIParse($conn,"select empno,ename from emp"); > > OCIExecute($statement,OCI_DEFAULT); > > echo "<TABLE Border=1>"; > > while (OCIFetch($statement)) { > > echo "<TR>"; > > echo "<TD>" . OCIResult($statement,"EMPNO") . > > "</TD>"; > > echo "<TD>" . OCIResult($statement,"ENAME") . > > "</TD>"; > > echo "</TR>"; > > } > > print "</TABLE></HTML>"; > > OCIFreeStatement($statement); > > OCILogoff($conn); ?> > > > > Any help would be apreciate.