How to Retrieve BLOB Data In Oracle APEX

Question

I want to retrieve BLOB data from database table to Display Image Item called P4_COMPANY_LOGO

I have selected the source for Display image item as SQL Query (Return Single Value):

select company_logo from companies where company_id=10;

But when I run the page it immediately return this Error:

P4_COMPANY_LOGO has to have a valid BLOB column as source.

Help Please!..

Tony Andrews · Accepted Answer · 2016-08-16 09:22:20Z

1

Maybe you don't have the item properties quite right. This would work:

answered Aug 16, 2016 at 9:22

Tony Andrews

133k23 gold badges230 silver badges266 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1