SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating and Saving a PDF as a flat file using PL SQL

655651Nov 17 2008 — edited Nov 18 2008

I'm currently trying to create and save a PDF as a flat file.

I can achieve this using APEX_UTIL.GET_PRINT_DOCUMENT to create the PDF as a blob then use UTL_FILE.put_raw to write it to a specificed location.

Is there anyway a PDF can be saved without using blobs?

'We' currently use and RTF template with an XML object.

We have BI Publisher but i am unable to find a method of invoking it from PL SQL without using blobs.

Current versions being used.
BI publisher 10.1.3.3.1
APEX 3.1.2.00.302
Oracle 10g.

Any help much appreciated.

Thankyou

John.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 16 2008

Added on Nov 17 2008

4 comments

757 views