This content has been marked as final. Show 4 replies
SSVS wrote:You can download images - GIF, BMP, PDF, and JPEG - I haven't tried TIFFS - using a standard routine based on WPG_DOCLOAD.download_file and OWA_UTIL.http_header_close that worked well for us late last year. Unfortunately this method did not work with .xlsx or .docs files, recognizing them as .zip files. My time on the project ended before we sorted out the .zip issue.
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.
One of the suggested fixes involved specifying file types in Apaches setup files. I was unable to test this on my laptop because I used the embedded PL/SQL gateway and had no apache files to modify.
I know there a way to achieve this using the http://oraclebizint.wordpress.com/2007/12/10/oracle-bi-ee-101332-displaying-blob-images-using-plsql-gateway/I created a page linking to the BLOB and downloaded it. The image did not render the way I wanted it to until I referenced the page through an iframe; when linking to the page directly it wiped out everything else on the Apex page until I used the iframe.
However I am not sure how to achieve 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.
Thanks for the response, i was following this post : Re: DAD error and this helped in creating that procedure and this is working for doc, zip and xls.
Now this http call could be used in OBIEE to report on this BLOB.
Thanks and Regards,
Edited by: SSVS on Jan 29, 2013 1:14 PM