Home » Other » Training & Certification » Oracle Database PL/SQL 11.2 Mail Packages
Oracle Database PL/SQL 11.2 Mail Packages [message #475383] Tue, 14 September 2010 13:01 Go to next message
Abeer30
Messages: 110
Registered: March 2007
Senior Member
Hi,

I am a little bit confused between the two packages UTL_MAIL and UTL_SMTP.

In Oracle® Database PL/SQL Language Reference 11g Release 2 (11.2) E10472-06, I found no reference to the package UTL_MAIL, only UTL_SMTP is mentioned there as the package that Sends electronic mails (emails) over Simple Mail Transfer Protocol (SMTP).

Would someone please provide me with a definition for the two packages above? and the database release for each, as well.

Thank you...
Re: Oracle Database PL/SQL 11.2 Mail Packages [message #475384 is a reply to message #475383] Tue, 14 September 2010 13:07 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
UTL_SMPT was released with V8.1.6
UTL_MAIL was released with V10.1 & handles attachments

SQL> DESC UTL_SMTP
SQL> DESC UTL_MAIL
Re: Oracle Database PL/SQL 11.2 Mail Packages [message #475385 is a reply to message #475384] Tue, 14 September 2010 13:12 Go to previous messageGo to next message
Michel Cadot
Messages: 59149
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think you didn't search very well in 11.2 documentation, it took me 10 seconds to find the reference:
http://download.oracle.com/docs/cd/E11882_01/appdev.112/e16760/u_mail.htm#i1001258

Regards
Miche!l
Re: Oracle Database PL/SQL 11.2 Mail Packages [message #475509 is a reply to message #475385] Wed, 15 September 2010 06:37 Go to previous message
Abeer30
Messages: 110
Registered: March 2007
Senior Member
Thank you blackswan for your reply.

Thank you Michel Cadot for the valuable link.
Previous Topic: Which certification should i take.
Next Topic: Oracle Clinical Data Management Training in Chennai
Goto Forum:
  


Current Time: Sun Sep 21 23:28:25 CDT 2014

Total time taken to generate the page: 0.08225 seconds