Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Viewing Data From BLOB

user518071Apr 19 2011 — edited May 20 2011
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 17 2011
Added on Apr 19 2011
2 comments
485 views