How to read and store a blob object

[Anon]

We are suffering to find out the way how to store and retrieve a blob datatype in an oracle database using PHP coding.

[Anon]

Hope this helps...

<?php
$conn=OCILogon("user", "pass","SID");
$lob1 = OCINewDescriptor($conn,OCI_D_LO😎;
$stmt = OCIParse($conn,"select blob_r_image into :lob1 from res_image_blob where doc_id='560-
0001-6744'");
OCIDefineByName($stmt,"BLOB_R_IMAGE",&$lob1);
OCIExecute($stmt,OCI_DEFAULT);
Header("Content-Type: image/tiff;");
while(OCIFetchInto($stmt,&$lob1,OCI_ASSOC+OCI_RESULT_CLO😎) {
$aa = $lob1['BLOB_R_IMAGE']->load();
echo $aa."<br>";
}
print "</pre>";
OCIFreeStatement($stmt);
OCILogoff($conn);
?>

-Kevin