1 Reply Latest reply: Jan 28, 2013 10:33 AM by Srini VEERAVALLI RSS

    Use PL/SQL gateway to report BLOBS in OBIEE

    Turbokat
      Hi All,

      I wanted to find out if there is way to report on BLOB data in the db table containing word documents,gifs,tifs and pdf files which needs to be displayed as HTTP link in the report data so when the users click these attachments / show in the browser inline.

      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 TYPES like PDF , DOC , JPEG etc, the above blog post shows/explains a proc for downloading 'gif's mime blobs to browser.

      I have never used Oracle APEX before, Please let me know if anyone has tried this approach and if this would be feasible at all.?

      Appriciate any help on this.!!

      Thanks in advance.
      SVS
        • 1. Re: Use PL/SQL gateway to report BLOBS in OBIEE
          Srini VEERAVALLI
          I didnt used it but just going thru the page. I think you need to change this piece of code from image to a file.
          ie. IMG to link as below

          <IMG SRC=”http://10.177.62.122:7779/apex/blob1.custom_image_display?p_imageid=’||CAST(RCOUNT(GEOGRAPHY.REGION_NAME) AS CHAR)||’” WIDTH=”41″ HEIGHT=”41″ BORDER=”0″ ALT=”BLOB IMAGES”>


          <a href=”http://10.177.62.122:7779/apex/blob1.custom_image_display?p_imageid=’||CAST(RCOUNT(GEOGRAPHY.REGION_NAME) AS CHAR)||’” target="_new">Link</a>