OraFAQ Forum: SQL & PL/SQL » Generating PDF files at oracle 10g server

Home » SQL & PL/SQL » SQL & PL/SQL » Generating PDF files at oracle 10g server (oracle 10g Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Generating PDF files at oracle 10g server [message #611742]

Tue, 08 April 2014 06:33

manyal
Messages: 84
Registered: March 2005

Member

Hello friends,

I need to generate PDF files at the server, based on the data stored in the database , I would like to prefer PL/SQL for the same can anyone please guide me a little in this regard.

Thanx in advance.

Manish

Report message to a moderator

Re: Generating PDF files at oracle 10g server [message #611745 is a reply to message #611742]

Tue, 08 April 2014 06:41

Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Google knows how. Have a look at Create PDF Files with PLSQL in Oracle, for example. Or Wpdf. Or PL/PDF.

Report message to a moderator

Re: Generating PDF files at oracle 10g server [message #611788 is a reply to message #611745]

Wed, 09 April 2014 00:24

manyal
Messages: 84
Registered: March 2005

Member

thanx littlefoot for your suggestion and I have started work in this direction.

[Updated on: Wed, 09 April 2014 00:25]

Report message to a moderator

Re: Generating PDF files at oracle 10g server [message #611978 is a reply to message #611788]

Thu, 10 April 2014 09:11

VladGab
Messages: 11
Registered: March 2014

Junior Member

If you can gather your data from database in .XML format I hava written java function which receives .XML as clob and returns .pdf as BLOB

Report message to a moderator

Re: Generating PDF files at oracle 10g server [message #611981 is a reply to message #611978]

Thu, 10 April 2014 09:25

Michel Cadot
Messages: 68764
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Can you post it.

Report message to a moderator

Re: Generating PDF files at oracle 10g server [message #611984 is a reply to message #611981]

Thu, 10 April 2014 09:36

VladGab
Messages: 11
Registered: March 2014

Junior Member

The code is more than 600 rows, and for running that java source need to grant additional permissions so if you really need this I can explain, but if it is only interesting for you let's don't blow each other time.

Report message to a moderator

Re: Generating PDF files at oracle 10g server [message #611993 is a reply to message #611984]

Thu, 10 April 2014 12:33

Michel Cadot
Messages: 68764
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I don't understand, you offer to share your code, if you post it I will sure study it even if I have no immediate need of it, what I am sure is that it will help some people that will search on the web for such solution, today, tomorrow, in a week, a month, a year, it does not matter, it will.
If you don't want to take time to explain it and Java permissions, it is not a problem I will add these information, just put the code and what it is needed to run it.
Note that 600 lines is not so big and some have already posted SQL queries to optimize which contain more lines. Sad

Report message to a moderator

Previous Topic:	How to fetch last N records from the table?
Next Topic:	date column issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 03 01:14:49 CDT 2025