[SOLVED] Displaying BLOBs on web page

[stockton]

Can someone suggest a method whereby one retrieves an Oracle BLOB &

subsequently display same on a HTML page?

If possible an example would be great.

[Feenix566]

$get_doc = OCIParse($DB, "select filename, blobfile from table");
if(!OCIExecute($get_doc))
   exit('failed to search for documents');
while($doc = oci_fetch_array($get_doc, OCI_NUM+OCI_RETURN_LOBS))
   echo $doc[0] . "\n" . $doc[1] . "\n";
OCIFreeStatement($get_doc);