Manish, January 06, 2009 - 2:05 pm UTC
Third party plug in
MojoMark, January 06, 2009 - 2:07 pm UTC
You might also give http://www.plpdf.com/
a try. It is a wrapped PL/SQL package that will generate a PDF as a blob that you could store in the database and/or serve to the user via HTTP.
While somewhat limited, it works well and it's cheap.
How about XML Publisher?
Srini, January 30, 2009 - 1:07 pm UTC
With reference to generating PDF documents from oracle, wouldn't using XMLPUB be easier? Most of the oraapps reports are already getting converted into XMLPUB reports.
We can generate XML data from PLSQL and use this as a source for the XML Publisher.
What do you think?
January 30, 2009 - 4:19 pm UTC
that is how APEX does it.
They did the task of getting it all working together - you can just reuse their work.
BI Publisher with OAS
Dieter Oberkofler, February 01, 2009 - 4:02 am UTC
We have also looked into BI Publisher but I understand that BI-PUB requires the complete OAS infrastructure to be used and would not run just on an Oracle Database Server.
I'm also wondering if BI-PUB is restricted to be used with APEX or would also work in conjunction with a simple mod_plsql application?
February 02, 2009 - 10:17 am UTC
... I'm also wondering if BI-PUB is restricted to be used with APEX or would also
work in conjunction with a simple mod_plsql application?
since APEX is nothing more than a simple mod_plsql application - the answer is yes.
See the link above in the original answer - it has all of the setup for both ways to do the pdf printing by APEX and those details answer the first bit (no, it does not run in the database, it doesn't need a full up iAS implementation - does need oc4j)
Sam, February 15, 2010 - 7:30 pm UTC
Does apex come preinstalled with those report servers (i.e oracle report publisher or apche FOP) ?
Would those serve the same thing Crystal reports does (i.e create a report layout and select fields and generate PDF reports dynamically)?
Arpan, February 12, 2013 - 5:32 am UTC
can any one please help me to solve the following problem from pl_fpdf.
I've already the package compiled successfully in my DB.
but still am unaware of this thing that how to create the output pdf and how to set the destination of the pdf file?
February 12, 2013 - 7:40 am UTC
the plpdf site - which "owns" this software - has a support link on it, I'd suggest trying that.
Oracle itself has nothing to do with plpdf.
Cloink, July 11, 2016 - 4:41 pm UTC
URL shared is not working
Chaitali, March 16, 2018 - 8:40 am UTC