Re: Need help with CLOB

On Fri, Aug 18, 2000 at 06:13:40PM +0200, Thierry Missimily wrote: > 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"; $var = $clob->load(); // will get you your data! > } > > I get : > > Before clob In loop Object > > > -- > Best regards, > > Thierry Missimilly > > > > +-------------------------------------------------------------------+ > Thierry Missimilly Éþ p?ZÒÔÛvÖ‚ > _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 > +-------------------------------------------------------------------+ > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" Digital Collections Phone +49 40 235350 Fax +49 40 23535180 Hammerbrookstr. 93 20097 Hamburg / Germany