Oracle APEX display blob images directly in a report

1
votes

I would like to know how one can display image type BLOBs uploaded as per this stack overflow question Use of BLOB type column in Oracle APEX, as images in a classic or interactive report instead of the normal download links.

I noticed that you can change the blob column attribute's Content Disposition field to inline, which then allows you to click through to another page where the image is displayed; but I want the image to display directly in the report without having to click on it.

The inline image displayed in a new page has the following url

https://apex.oracle.com/pls/apex/apex_util.get_blob?s=34564408462&a=4794&c=16789110088070077&p=2&k1=21&k2=&ck=D4QFl4Z9txsufDbmUOmKeirK4&rt=CR

which suggests that one might be able to use apex_util.get_blob. Does anyone know how this can be accomplished?

1
imagebloboracle-apex
I would suggest installing the "Sample Database Application" from pre-packaged apps and see how it's done there for the product pages. – Scott

1 Answers

2
votes

I have implemented same in classic report.

I followed this link http://docs.oracle.com/cd/E14373_01/apirefs.32/e13369/apex_util.htm#AEAPI129 This may help you to resolve your doubts