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!

Classic Report shows no_data_found when images column type is "Display Image".

Eslam_ElbyalyJun 9 2020 — edited Jun 9 2020

Apex 18.2.

Hi,

I have a page with a classic report region based on a sql query that retrieves a dbms_lob.getlength(img_column) besides other data. If the image column type is plain text, data are retrieved. But if I change it to "Display Image", it throws no_data_found error.

I noticed that that happens only if I create a report page. But if I create a "Reprot with a Form", the report shows normally. I have created a report with a form and the report was working properly and suddenly it's not working anymore. I do not remember something changed. Is this a bug? Most importantly is there a solution.

https://apex.oracle.com/

ws = ESLAM_WS

user = forhelp

pwd = forhelppass

app = Help

pages 5 and 6 are report with a form.

page 7 = Only the report with same query but it throws the error!

This post has been answered by fac586 on Jun 9 2020
Jump to Answer

Comments

Post Details

Added on Jun 9 2020
2 comments
696 views