Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Render a BLOB column that contains PDF data

Received Response
62
Views
3
Comments
Victor H
Victor H Rank 6 - Analytics Lead
edited May 2, 2024 9:13PM in Oracle Analytics Publisher

IN OBIEE /BIP it is possible to render an image stored as a BLOB file; however we have not found a way to render application/pdf content in a similar way.

How can this be done?

OAC,OBIEE , BIP any tool that can do this apart from APEX?

Tagged:

Answers

  • SteveF-Oracle
    SteveF-Oracle Mod

    A BLOB will be returned in hex encoded stream (base64) to Presentation Server, you would need a piece of custom javascript that decodes it and converts it back to its original form.

  • Victor H
    Victor H Rank 6 - Analytics Lead

    @SteveF-Oracle We can only do this with images

    <fo:instream-foreign-object content-type="image/jpg"><xsl:value-of select="IMAGE"/></fo:instream-foreign-object>

    If we use application/pdf it does not render the pdf

  • SteveF-Oracle
    SteveF-Oracle Mod

    I am not sure you will be able to actually render it. I do remember we used to have an example in one of the old OBIEE sample virtual machines (v511, I think), that demonstrated using JS to decode a PDF, then have a link to download it.