Home » SQL & PL/SQL » SQL & PL/SQL » Can we create a PDF File attachment and send as a mail using PL/SQL
Can we create a PDF File attachment and send as a mail using PL/SQL [message #289207] Thu, 20 December 2007 03:56 Go to next message
convey05
Messages: 43
Registered: December 2007
Location: CHENNAI
Karma: 0
Member
Can we create a PDF File attachment and send as a mail using PL/SQL-ORACLE
Re: Can we create a PDF File attachment and send as a mail using PL/SQL [message #289208 is a reply to message #289207] Thu, 20 December 2007 04:01 Go to previous messageGo to next message
Michel Cadot
Messages: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Karma: 0
Senior Member
Account Moderator
Create, not within Oracle unless you have a Java class that can do it.
Send, yes, as any other attachment.

Regards
Michel
Re: Can we create a PDF File attachment and send as a mail using PL/SQL [message #289328 is a reply to message #289208] Thu, 20 December 2007 13:36 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Karma: 0
Senior Member
http://forums.oracle.com/forums/thread.jspa?messageID=1103801&#1103801

There are many ways to attach the PDF to the email, using either PL/SQL, Java or at the OS level. You shouldn't need to mess directly with low level packages. Start by looking at UTL_MAIL in 10g.

[Updated on: Thu, 20 December 2007 13:40]

Report message to a moderator

Re: Can we create a PDF File attachment and send as a mail using PL/SQL --very urgent [message #290703 is a reply to message #289328] Mon, 31 December 2007 03:09 Go to previous messageGo to next message
convey05
Messages: 43
Registered: December 2007
Location: CHENNAI
Karma: 0
Member
Hi,
can u tell me how to create and send a PDF attachment using oracle pl/sql
Thanks in advance
Re: Can we create a PDF File attachment and send as a mail using PL/SQL --very urgent [message #290706 is a reply to message #290703] Mon, 31 December 2007 03:19 Go to previous message
Michel Cadot
Messages: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Karma: 0
Senior Member
Account Moderator
Read the previous posts.
And search on AskTom.

Regards
Michel
Previous Topic: Procedure undefined-ORA-06550 error
Next Topic: simple select with ORA-00904
Goto Forum:
  


Current Time: Tue Aug 22 10:06:54 CDT 2017

Total time taken to generate the page: 0.13483 seconds