OCIFetchInfo fails with LOBs
| From: | Andreas Jung | Date: | Fri, 12 May 2000 11:37:44 +0000 |
| Subject: | OCIFetchInfo fails with LOBs | ||
| Groups: | php.version4 | ||
| Request: | Send a blank email to php-version4+get-14903@lists.php.net to get a copy of this message | ||
Hi,
I have the following code to read the CLOB 'inhalt' from a table fulltext:
$conn = OCILogon("ajung","thissux","suxdb");
$stmt = ociparse($conn,"select docnum,inhalt from fulltext where
contains(inhalt,'Feuerwehr within tidoc')>0");
OCIExecute($stmt,OCI_DEFAULT);
while(OCIfetchinto($stmt,&$arr,OCI_RETURN_LOBS)) {
echo $arr[0]."\n";
echo $arr[1]."\n";
}
This fails with the following error:
X-Powered-By: PHP/4.0RC2-dev
Content-type: text/html
6181-00
<br>
<b>Warning</b>: OCILobRead: OCI_NEED_DATA in <b>./test2.php3</b> on line
<b>13</b><br>
<br>
<b>Warning</b>: _oci_close_session: OCISessionEnd: ORA-03127: no new operations allowed
until the active operation ends
in <b>Unknown</b> on line <b>0</b><br>
Bug or feature ?!
Andreas