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 21.1: Classic Report not showing Image instead showing No Data Found...

SmithJohn45Nov 11 2021 — edited Nov 11 2021

created a classic report which should show related Images, written sql statement and using dbms_log.getlength(item_image), type = Display Image, set required attributes for Table Name, Blob Column, Primary Key etc. when run report it is throwing error:
report error: ORA-01403: no data found
when run my sql statement in sql command window, it was successfully showing the results.
please guide and help why it throws no data found? how it can be resolved?
screenshot:
image.pngregards
is there any report in Sample Reportings for this problem i can refer, i have installed and checked, it seems there is no sample Classic Report with showing images.

This post has been answered by fac586 on Nov 11 2021
Jump to Answer
Comments
Post Details
Added on Nov 11 2021
3 comments
1,552 views