Entry

Need to know how to Select Data from a Clob Field, ie. where clob ='blah'

May 3rd, 2004 18:50
Eyzen Medina, Christopher Boyce,

I think you can't do at this way.
When you retrieve a blob file you have to use a load function inside 
the oci library for example.
       $db = OCILogon("scott","tiger");
        $stmt = OCIParse($db,"select * from anydemo_with_blob_table");
        OCIExecute($stmt);
        while (OCIFetchInto($stmt,$arr,OCI_ASSOC)) {
		 echo $arr[ "LOBFIELD" ]->load()."\n";
		}
the table have a LOBFIELD type BLOB
So, you can create a varchar2 field description in the same table for 
this BLOB and search in this field.
I hope that this help you
Eyzen