Need help with CLOB

From: 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 +-------------------------------------------------------------------+

« previous php.general (#12490) next »