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!

Display a BLOB image in a browser

788536Jul 30 2010 — edited Sep 13 2010

Ok, I have an Oracle table that is storing jpeg images as BLOB's. What I want to do is read one of those BLOB's and display it on a web page. Sounds simple.

The catch is that I cannot first convert the blob to a file using UTL_FILE. The image will not be viewed as the entire contents of the page either, it needs to be inline with other text content. Our system has a PL/SQL back end that is generating all of the HTML. The database is Oracle 10g, pl/sql is 10.2.0.4.0. The only other technology that can be used is client side javascript.

Is this even possible? I've been held up by this problem for quite some time and would really appreciate any help I can get.

Thankyou

This post has been answered by MichaelS on Jul 31 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 11 2010

Added on Jul 30 2010

#plsql, #sql

4 comments

4,858 views