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.
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.