Home » SQL & PL/SQL » SQL & PL/SQL » CLCB to PDF File
CLCB to PDF File [message #220187] Mon, 19 February 2007 06:52 Go to next message
prabhuapps
Messages: 79
Registered: June 2005
Location: Bangalore
Member
All,

I have XML Data in CLOB Datatype variable. I need to read this and write into a pdf file. How to do this ?

Thanks in advance

Regards,
Prabhu

Re: CLCB to PDF File [message #220293 is a reply to message #220187] Tue, 20 February 2007 02:23 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Well, firstly, I'd put the XML data into an XMLTYPE, or at least a CLOB.

Secondly, your problem is going to be creating a PDF file. To the best of my knowledge there's no way to do this from within the database (unless someone knows of a 3rd party Java class for doing that sort of thing). If you use Oracle reports, you could create a report that produces its output as a pdf and run that. If you've got a reports server set up, then you can use utl_http to call the report from within pl/sql too.
Previous Topic: help needed
Next Topic: help needed in procedure
Goto Forum:
  


Current Time: Sun Dec 04 20:51:39 CST 2016

Total time taken to generate the page: 0.05303 seconds