Hi !
I need export picture from Oracle BLOB to file. I am trying with this code. but it's not worked ! Whats wrong? Any comments !
<?
$conn = oci_connect('dbase','login','pasw');
$PicId = $_GET['pic_id'];
$stmt = @OCIParse($conn, "SELECT resbody, resourceid FROM d_resource_body where resourceid=$PicId" );
if (!@OCIFetchInto($stmt, &$result, OCI_ASSOC ))
print("Picture PicId=$PicId not found in database");
Header("Content-type: image/jpeg");
$result['RESBODY']->export('/tmp/pc_pics/'.$result['RESOURCEID'].'jpg');
OCILogoff($conn );
?>
Thanks