Home » SQL & PL/SQL » SQL & PL/SQL » Send email with attachement through PL/SQL
Send email with attachement through PL/SQL [message #226955] Tue, 27 March 2007 00:30 Go to next message
aurigian
Messages: 9
Registered: September 2005
Location: pakistan
Junior Member

Hi
i m using oracle 9.2.0.1.0 and i m already create procedure which generate email and it's running fine but now i have a new task to generate email with attachment (Prob PDF) and this is where i stuck can any one help me on this



Regards
Shah Zahid Hussain
Re: Send email with attachement through PL/SQL [message #226968 is a reply to message #226955] Tue, 27 March 2007 00:38 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
UTL_MAIL
Re: Send email with attachement through PL/SQL [message #226995 is a reply to message #226968] Tue, 27 March 2007 01:38 Go to previous messageGo to next message
aurigian
Messages: 9
Registered: September 2005
Location: pakistan
Junior Member

thanx ur reply dear but utlmail package add in 10g and i m using oracle 9i
Re: Send email with attachement through PL/SQL [message #226997 is a reply to message #226995] Tue, 27 March 2007 01:42 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
I'd say: UTL_SMTP, but while I was verifying this at asktom.oracle.com, I came along this thread. A Java mail API might help you out.

MHE
Previous Topic: How to use trigger on blob column
Next Topic: Help with String (Instr)
Goto Forum:
  


Current Time: Sat Dec 03 03:54:52 CST 2016

Total time taken to generate the page: 0.09786 seconds