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!

Image stored in table is not showing in HTML region or report region

Sudhir_MeruAug 22 2012 — edited Aug 27 2012

Hi,

I am using apex 4.1 and database as oracle 11g.

I uploaded images and stored in table structure as shown below

>>CREATE TABLE "HR_EMPLOYEE_DETAILS"
>> ( "ID" NUMBER,
>> "HR_ID" NUMBER NOT NULL ENABLE,
>> "PHOTO_BLOB" BLOB,
>> "MIME_TYPE" VARCHAR2(64),
>> PRIMARY KEY ("ID") ENABLE
>> )

My Requirement is to show the image in a report region as well as in a html region. I followed the methods in the URL links mentioned below.

http://blog.hilandco.com/2010/05/how-to-show-blob-type-column-as-image.html

http://apex.oracle.com/pls/otn/f?p=31517:64:867421680099401:::::

But the image is not getting populated in the region, I tried with dispay_item with image i am able to view the image using this item.

Please suggest me. Is there any alternative way to show the image in apex 4.

Thanks
Sudhir

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 24 2012

Added on Aug 22 2012

#apex-discussions

19 comments

2,072 views