Create PDF

[hilbertl3]

Does anyone know how to create a pdf from an existing Excel or Word file using PL\SQL?

hilbertl

 

[SantaMufasa]

Hilbertl,

If your goal is to simply create a .pdf file from the contents of Excel or Word, then going through PL/SQL is an necessary step.

I recommend your downloading PDF995, which is a free download that converts anything into a .pdf file. Once you download the software, PDF995 becomes a printer choice along with your other printer choices. You simply output to the PDF995 "printer" and it converts the output to a .pdf file that you specify.

Let us know if this solution meets your need.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[markrem]

One way to do this is using Oracle ExtProc. First, get a PDF generator like the earlier poster said. Then, configure your Oracle listener for extproc. Then, you must create a C or Java program at the operating system level that calls the PDF software and passes parameters necessary to generate a PDF file. Finally, write the PL/SQL code in your database that makes an extproc callout and invokes that Java or C program.
Cheers,


MarkRem
Author, Oracle Database 10g: From Nuts to Soup

http://www.remidata.com/book_nuts2soup.htm

 

[hilbertl3]

Thank you for your help, but will your suggestions work on the conversion of an existing Excel file or Word file to a pdf, Mufasa and Mark?


H.

 

[SantaMufasa]

Hilbertl,

If you use the option that I describe, above, then yes, anything that you try to print to the "PDF995" printer on your printer list, then appears (WYSIWYG) in a .pdf file, regardless of when you create the Excel or Word file...that's why this option is so easy and trouble free.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[hilbertl3]

markrem,

"Then, you must create a C or Java program at the operating system level that calls the PDF software and passes parameters necessary to generate a PDF file."

When you say at the operating system level, do you mean on the Oracle database server (in our case Unix) or on the user's machine (in our case Windows 2000)?

hilbertl