Skip to main content

Generate PDF files from HTML DB w/out Java!

The question: How do I print PDF documents with HTML DB?

The answer (maybe): PL/PDF

Looks like the folks at PL/PDF have some instructions on how to set it up in an HTML DB environment. For only $300, it seems like a good deal. It's not WYSIWYG, but the code for a complex master-detail report, which contains page breaks and headings on each page, is not that bad.

If you host your HTML DB site with Revion, PL/PDF is even included as a part of their package.

I have not tested this out yet, but am anxious to do so, as I'm sure it will come in handy!


colin said…
The product looks impressive for what it is supposed to do. Looking throught rhe revision history, it apprears to be regularly improved upon.

The only problem is that you cannot conveniently buy it online, forced to use a Telegraphic Transfer form of payment.
Robert said…
>> The answer (maybe): PL/PDF

I agree.
That was what I thought when I read about it in a forum thread.
For a little money you avoid the nitty-gritty and get things done.
Scott said…
It is worth a look, as quite honestly, there just isn't anohter viable solution for many people. Sure, you can use Oracle Reports, but it's 1) not cheap and 2) not that easy to use.


- Scott -
Anonymous said…
This software is a good hint.
Our similar problem was how to convert simply ascii-reports (generated to files in the operating system) to pdf-files.
Our approach to solution was
* use existing oracle reports server
* one report which makes a select * from the ascii-file using external tables
* within the db: utl_http to call the report via web and store the pdf-file into a blob or again back into the filesystem
(our issue was that we had no direct access to the file-system exception for utl_file).
Anonymous said…
Any word on testing this product? Just wondering if you had time to test and comment your thoughts.
Scott said…
I took a look at it a while back, and it looked promising.

You do have to write code to get things to work, so it's a bit abstract in that regards. Think of it as hand-coded PL/SQL web pages for PDF Reports...

There is a good chance that I will be using it for an upcoming project where PDF printing is a requirement.

You can download & try it for free, and there are plenty of helpful examples to get you up & running.


- Scott -
Anonymous said…
Is'nt Oracle Reports just $50 per named user?
Question: can it be used with Oracle XE?
Scott said…
Is'nt Oracle Reports just $50 per named user?

I believe that it's MUCH more than that, but I could be wrong...

Question: can it be used with Oracle XE?

According to the PL/PDF site, yes:


- Scott -
Anonymous said…
I purchased two PL/PDF licenses and have been using them with Apex 2.1 in Oracle XE.

I generate my reports using PL/PDF which is then presented to the user in an Apex HTML region using an IFRAME to embed the report into the web page.

Works great. Looks great. Note that you will be hand-coding your reports - this is not some high-level report generator. But for me, this is exactly what I was wanting.
Sourabh said…
Is there any way we can use PL/PDF to convert HTML into a PDF form?
Something like... "Pass a URL/BLOB that provides a well formed HTML to PL/PDF and get a PDF document".
Rather than using an external service to do this I would like to use PL/PDF for this purpose.
Has anyonr tried anything on these lines??
Anonymous said…
I saw a free pl/sql package that generates PDF. That does the stuff without java.
Scott said…
Interesting... I'll have to check it out and see how it compares to PL/PDF.


- Scott -

Popular posts from this blog

Thanks, ODC (Oracle Developer Community)!

I owe a lot of thanks to the ODC - which stands for Oracle Developer Community.  What is ODC?  You may remember it as OTN, or the Oracle Technology Network.  Same people, different name.  Why they changed it I can't say.  People just liked it better that way... (love that song)

In any case, what am I thankful for?  A lot.  To start, the tools that I use day in and day out: SQL Developer, ORDS, Oracle Data Modeler, SQLcl and - of course - APEX.  Without these tools, I'm likely on a completely different career path, perhaps even one that aligns more closely with my degree in television management.

While the tools are great, it's really the people that make up the community that make ODC stand out. From the folks who run ODC and the Oracle ACE program to the developers and product managers who are behind the awesome tools, the ODC community is one of, if not the greatest asset of being involved with Oracle's products.

If you have yet to get more involved with this communi…

Spaced Out

A while back, I wrote about how to give the Universal Theme a face lift.  If you follow the steps in that post, the base font for an APEX application with the Universal Theme can easily be changed.

While that's all well and good, sometimes you only want to change the font for a report, not the entire page.  One of the applications that I'm building contains a number of IRs based mostly on log data.  Thus, having that data in a monospaced font would make it a whole lot easier to read.

You can search Google Fonts for monospaced fonts by selecting only that option on the right-side menubar.  You can also opt for the standard yet kinda boring Courier and achieve the same thing.

To implement this in your application, follow the steps in my other post, but stop shy of the final step.  Instead of pasting in the text that I specify, paste in the following to the Custom CSS field in Theme Roller, using the name of the font you selected for the font-family:

.a-IRR-table tr td { font-fam…

Whose Deck is it Anyways?

This year at KScope, we're going to try something new.  And fun.  And funny to watch - we hope.  It's called "Whose Deck is it Anyways?", and will occur on Sunday at 8:30pm.  It's only 30 minutes, but it will likely be the best 30 minutes of the conference.  Or at least the most embarrassing.

Here's what we're going to do: the will be four 5-minute presentations - one on each of the following: BI, EPM, Database & APEX.

Sound interesting?  Probably not.  We get that, too.  So here's what we did.

Each 5-minute session will be presented by a non-expert.  For example, it's highly likely that I'll be presenting on BI or EPM.

To make it even better, each slide deck will be prepared by the corresponding expert.  So again, it's highly likely that my slide deck's creator will be either Stewart Bryson or Edward Roske.  If nothing else, this session will be a crash course in how not to make cohesive, easy to read slides.

Interested now?  Ya,…