note 64543 deleted from function.oci-fetch-array by sixd
| From: | sixd@php.net | Date: | Wed, 18 Nov 2009 22:48:29 +0000 |
| Subject: | note 64543 deleted from function.oci-fetch-array by sixd | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-163052@lists.php.net to get a copy of this message | ||
Note Submitter: antonchanning at gmail dot com
----
As Robert Hicks mentioned back in August 2004 there is an error in examples 3 and 4 of this page.
The error in example 3 is what dwhitaker and stry_cat address in their notes of 20 May 2005 and 9
June 2005 respectively.
The correct form of example 4 should read:
<?php
$connection = oci_connect("user", "password");
$query = "SELECT id, name, lob_field FROM fruits";
$statement = oci_parse ($connection, $query);
oci_execute ($statement);
while ($row = oci_fetch_array ($statement, OCI_RETURN_LOBS)) {
echo $row[0]."<br>";
echo $row[1]."<br>";
echo $row['LOB_FIELD']."<br>"; //this will output LOB's content
}
?>
This really should be corrected in the actual documentation...