This discussion is archived
4 Replies Latest reply: Jan 29, 2013 1:15 PM by Turbokat RSS

Using PL/SQL Gateway for creating HTTP links for BLOB in Db table

Turbokat Pro
Currently Being Moderated
Hello Gurus,

I wanted to find out if there is way to report on BLOB data in the database table containing word documents,gifs,tifs and pdf files which need to pulled in the report as attachments / show in the browser inline as a html link.

I know there a way to achive this using the http://oraclebizint.wordpress.com/2007/12/10/oracle-bi-ee-101332-displaying-blob-images-using-plsql-gateway/

However I am not sure how to achive this functionality for all the MIME TYPE like PDF , DOC , JPEG etc, the above blog post shows/explains a proc for creating a HTTP link for these blobs to browser. So that I can we can make use of this link in the OBIEE report.

Please let me know if anyone has tried this approach and if this would be feasible at all.?

We are planning to use the default APEX 3.2 that comes with Oracle 11g DB install by default.

Thanks in advance.
SVS

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points