CODEWITHSUNDEEP
sqloracle-apex
Saddam Meshaal
Saddam Meshaal

Reputation: 552

How to Retrieve BLOB Data In Oracle APEX

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!..

Upvotes: 0

Views: 2973

Answers (1)

Tony Andrews
Tony Andrews

Reputation: 132570

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

enter image description here

Upvotes: 1

Related Questions