Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Kay.

Asked: September 20, 2021 - 12:52 pm UTC

Last updated: September 23, 2021 - 7:24 am UTC

Version: 19

Viewed 1000+ times

You Asked

Is there a way to create a pdf in memory and save it in a blob?
We don’t want to create a database directory and create the actual pdf on the server.
So, I am looking for a way to create it in memory and insert it into a blob field using pl/sql or a database procedure written in Java.

and Connor said...

There's a few options you could explore here

Basic options:

https://technology.amis.nl/it/as_pdf-generating-a-pdf-document-with-some-plsql/
https://github.com/grlicaa/GEN_PDF

Commercials Offering: PL/SQL

https://www.plpdf.com/

Also, if you're an APEX user (free product) then the APEX_DATA_EXPORT package allows exporting data as PDF


Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

APEX

Keep your APEX skills fresh by attending their regular Office Hours sessions.