How to create pdf reports using PL/SQl

Question

Is there pl/sql package or engine avalable which would enable the creation of PDF reports from stored procedures?

Answer 1

Hi,

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

Answer 2

You may want to look into Oracle Application Express to create PDF reports, but depending on how the output is coming out from your stored procedure, it may not be an easy tool to use.

You can find directions here: http://www.oracle.com/technology/obe/apex/apex31nf/apex31rpt.htm#t1

Answer 3

For more information about how to use the open source PL_FPDF, see my blog post: http://ora-00001.blogspot.com/2009/10/free-pdf-package-for-plsql.html

For the commercial PL/PDF package, see http://www.plpdf.com/

Answer 4

Oracle Application Express - printing features not to be forgotten. You can use interactive reporting from browser and decide what you need to print. You can apply XSLT also and decide the printing format.