Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Viewing BLOB attributes in OBIEE

Received Response
1
Views
1
Comments
702531
702531 Rank 1 - Community Starter
edited Aug 13, 2024 5:19PM in Oracle Analytics Forum

Hi,

I have a table in an Oracle database with documents saved in BLOB format. I want to show this through OBIEE in a browser.

Column is already added with LOOKUP function tot eh BI Server so that is OK, but I need the last bit where I can view the (mainly PDF's) in browsers.

Any help would be highly appreciated.

Regards

Alf Eirik Nordmo

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    I would say your only chance would be to look in how images stored in the DB can be displayed.

    Your blob isn't a PDF, it's a bunch of 0 and 1, that's it.

    Your browser understand that a URL is a PDF thanks to some headers telling what is the time of the content it's about to receive, so you would have to go through something similar.

    Probably using some JS you could fake it and let your browser know what the stream of 0 and 1 you are sending is.