Skip to Main Content

APEX

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 single BLOB image stored in table in an HTML region

LauryJan 9 2014 — edited Apr 28 2014

Hi,

I which to display a BLOB file initially stored in a table (in my case an image or jpg picture) in an HTML region in APEX (APEX 4.2).

My BLOB is extracted as the following:

select

    picture_id, => the unique value ID of the image

    stored_picture, => the BLOB image

    mimetype, -> the type for the image, here, jpg

    filename => the name of the image (this is just a text file)

from

    application_pictures

where

    picture_id = VALUE_1;

What kind of HTML region should I use in APEX?

- HTML text

- HTML Escape Special Character

- Dynamic PL/SQL

Can someone exlain me how this can be achieved?

Thanks by advance for any tip.

Kind Regards

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 26 2014
Added on Jan 9 2014
10 comments
19,215 views