OraFAQ Forum: Training & Certification » Oracle Database PL/SQL 11.2 Mail Packages

Home » Other » Training & Certification » Oracle Database PL/SQL 11.2 Mail Packages

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

Oracle Database PL/SQL 11.2 Mail Packages [message #475383]

Tue, 14 September 2010 13:01

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...

Report message to a moderator

Re: Oracle Database PL/SQL 11.2 Mail Packages [message #475384 is a reply to message #475383]

Tue, 14 September 2010 13:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator

Re: Oracle Database PL/SQL 11.2 Mail Packages [message #475385 is a reply to message #475384]

Tue, 14 September 2010 13:12

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

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

Report message to a moderator

Re: Oracle Database PL/SQL 11.2 Mail Packages [message #475509 is a reply to message #475385]

Wed, 15 September 2010 06:37

Abeer30
Messages: 110
Registered: March 2007

Senior Member

Thank you blackswan for your reply.

Thank you Michel Cadot for the valuable link.

Report message to a moderator

Previous Topic:	Which certification should i take.
Next Topic:	Oracle Clinical Data Management Training in Chennai

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 14 00:42:31 CST 2025