Viewing Data From BLOB
Hi,
Before asking this question I did my DD by googling as well as searching this forum for the answer.
I've two tables.In one table along with other columns,I've one column called 'BLOB_ID' which is linked to another table where attachments from front end forms are stored in BLOB.This blob stores attachments of various file types like doc,pdf,bmp,gif,jpg etc.Is there anyway I can see these attachments by using DBMS_OUTOPUT?
I tried utl_raw.cast_to_nvarchar2,dbms_lob but I'm getting junk characters as output as atatchments are in their proprietary format(PDF,doc etc).I tried querying in sqldeveloper and clicking on blob with external editor with Mime option but no luck?
Thanks,
Mahender.