How to create PDF reports using PL/SQL

Question

Is there PL/SQL package or engine available which would enable the creation of PDF reports from stored procedures?

Answer 1

If your looking for a freeware or open source package, their is this. I've not used it, but it has good reviews. lPL_FPDF If you have a budget, then this, which enterprise class product, meaning excellent documentation, is available. plpdf.

The commercial package is written in native Pl/SQL so will be very easy to use. The open source package I don't know.

If your running in an Oracle environment, with any of the reports servers, then all of then support PDF being emitted both to the printer and stored in the db as blobs. Its a fairly tedious task to configure it, from what I remember.

Hope that gets you started. B