CODEWITHSUNDEEP
imagebloboracle-apex
Superdooperhero
Superdooperhero

Reputation: 8096

Oracle APEX display blob images directly in a report

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?

Upvotes: 0

Views: 21121

Answers (1)

Amol
Amol

Reputation: 428

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

Upvotes: 3

Related Questions