Render a BLOB column that contains PDF data

Question

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?

Steve F-2 · Answer

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.

Victor H · Answer

@SteveF-Oracle We can only do this with images

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

Steve F-2 · Answer

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.