Retrieve XMLP documents from BLOB fields via PL/SQL and UTL_FILE.

screwj

Member
Hi,

Since E1 Tools Release 8.97, I am trying to retrieve all printed XML Publisher reports (PDF, RTF, HTML) from the BLOB fields in sy812.F95631. We are on Oracle 10g and have started using UTL_FILE to read from the BLOB and write it to a file. The problem is when I try to open in it in Word of Adobe, I basically get garbage.

The purpose is to be able to access printed reports without having to manually save each XMLP report manually. I want to be able to get direct access to the merged data so I can possibly open them from different applications (i.e. HTML).

Has anyone worked with this or possibly created a solution?

Thanks
 
I can probably create a solution - please, e-mail me a blob file to try...
 
Try using gunzip functionality ( from the open source zlib ) on the blob.
 
FYI, the tools release 8.98.1 and higher allow you to point output to the OS.
 
Back
Top