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!

APEX 5: Show BLOB - image in report

Wim MeysNov 10 2015 — edited Nov 19 2015

HI,

I'm trying to display a blob/image in a report, but get a NO DATA FOUND.

Here's my table

and Data in this table

I created a view on this table to use in APEX parsing schema.

This is the SQL I use in the report (tried Classic and Interactive report, btw).

This is how I set up the column in the report

When I run the page I get ORA-01403

When I set TYPE to PLAIN TEXT, it does find DATA.

So I must be doing something wrong by displaying the BLOB CONTENT as image.

Any ideas?

thx

Wim

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 17 2015
Added on Nov 10 2015
5 comments
10,420 views