Need help with CLOB
| From: | Thierry Missimily | Date: | Fri, 18 Aug 2000 16:13:40 +0000 |
| Subject: | Need help with CLOB | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-12490@lists.php.net to get a copy of this message | ||
Hi,
I whould like to query with PHP3, an Oracle database which contents a
CLOB field. But i can't print the result of the query.
ex :
$query = "select details ". // details is a
CLOB
"from metrology_errlog ".
"where target_id='$target_id' " ;
$stmt = OCIParse ($conn,$query);
$clob = OCINewdescriptor($conn,OCI_D_LOB);
OCIDefineByName($stmt, "DETAILS", &$clob,-1,OCI_B_CLOB);
OCIExecute($stmt);
print "Before clob\n";
while (OCIFetch($stmt)) {
print "in loop\n";
print "$clob";
}
I get :
Before clob In loop Object
--
Best regards,
Thierry Missimilly
+-------------------------------------------------------------------+
Thierry Missimilly mailto:Thierry.Missimilly@bull.net
BULL XSBU Phone :+33 (0)4 76 29 74 54
1, rue de Provence B.P. 208 Fax :+33 (0)4 76 29 78 62
38432 Echirolles Cedex FRANCE Poste :(229) 7454
+-------------------------------------------------------------------+