We use An Apache 1.3.12- PHP 4 server on debian linux which querys an Oracle
8.1.5 (with patch 0.2) server on a Debian linux.
When we do a SELECT statement,
we cannot manage to have more than a column or 3 row of return values, with every try we do (result,fetchint...)
A example file:
<?php
$conn = OCILogon("scott","tiger","listener");
$stmt = OCIParse($conn,"select empno, ename from emp");
OCIDefineByName($stmt,"EMPNO",&$empno);
OCIDefineByName($stmt,"ENAME",&$ename);
OCIExecute($stmt);
while (OCIFetch($stmt))
echo "empno:".$empno."\n";
echo "ename:".$ename."<br>";
}
OCIFreeStatement($stmt);
OCILogoff($conn);
?>
select empno, ename from scott.emp
empno:7369 ename:SMITH...
empno:7499 ename:ALLEN...<<
empno:7521 ename:WARD...<<
<<
Warning: OCIStmtExecute: ORA-03106: fatal two-task communication protocol
<<
WHAT HAVE I TO DO?
Ps:We can use use ora* functions in php, but it's not very powerful
