note 64543 added to function.oci-fetch-array
| From: | antonchanning at gmail dot com | Date: | Tue, 18 Apr 2006 08:59:42 +0000 |
| Subject: | note 64543 added to function.oci-fetch-array | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-108390@lists.php.net to get a copy of this message | ||
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...
----
Server IP: 84.18.202.180
Probable Submitter: 193.63.43.11 (proxied: 172.16.100.103)
----
X-Spam-Status: No, hits=3.3 required=5.0 tests=DATE_MISSING,FROM_NO_LOWER,
HTML_MESSAGE autolearn=no version=2.64
----
Manual Page -- http://www.php.net/manual/en/function.oci-fetch-array.php
Edit -- http://master.php.net/note/edit/64543
Del: integrated -- http://master.php.net/note/delete/64543/integrated
Del: useless -- http://master.php.net/note/delete/64543/useless
Del: bad code -- http://master.php.net/note/delete/64543/bad+code
Del: spam -- http://master.php.net/note/delete/64543/spam
Del: non-english -- http://master.php.net/note/delete/64543/non-english
Del: in docs -- http://master.php.net/note/delete/64543/in+docs
Del: other reasons-- http://master.php.net/note/delete/64543
Reject -- http://master.php.net/note/reject/64543
Search -- http://master.php.net/manage/user-notes.php