BI Publisher (MOSC)

MOSC Banner

Extract pdf file stored in blob in xmlp_sched_data

edited Jul 6, 2015 8:27AM in BI Publisher (MOSC) 1 commentAnswered ✓

Hello,

I am trying to get at the output generated by a bursting job scheduled within BI Publisher (part of OBIEE).

The XMLP_SCHED_DATA table stores the output file (pdf in my case) in compressed form in the "DATA' blob field. If I were to use SQL Developer to save the BLOB data into a file with a .zip extension, I can unzip the downloaded file but the file name seems to be "data.out".

But if I try to use the UTL_COMPRESS.lz_uncompress to uncompress this blob, I get an error saying :

29294. 00000 -  "A data error occurred during compression or uncompression."

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS BI Publisher Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center