PL/SQL Packages UTL_SMTP

Send e-mail via Simple Mail Transfer Protocol (SMTP).

Subprocedures:

connection Record Type 
           A PL/SQL record type used to represent a SMTP connection. 

reply, replies Record Types 
           Record types used to represent an SMTP reply line.  

open_connection Function 
           Open a connection to an SMTP server. 

command(), command_replies() Functions 
           Perform a generic SMTP command. 

helo Function 
           Perform initial handshaking with SMTP server after connecting. 

ehlo Function 
           Perform initial handshaking with SMTP server after connecting,
           with extended information returned. 

mail Function 
           Initiate a mail transaction with the server.
           The destination is a mailbox. 

rcpt Function 
           Specify the recipient of an e-mail message. 

data Function 
           Specify the body of an e-mail message. 

open_data(), write_data(), write_raw_data(), close_data() Functions 
           Provide more fine-grain control to the data() API. 

rset Function 
           Abort the current mail transaction. 

vrfy Function 
           Verify the validity of a destination e-mail address. 

noop() Function 
           The null command. 

quit Function 
           Terminate an SMTP session and disconnect from the server.

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"
or the book Oracle Built in Packages by Steven Feuerstein et al

Related:

DBMS_AQELM
JavaMail from Sun has more functionality: royalty-free binary for JavaMail, IMAP, POP3 and SMTP


© Copyright SS64.com 1999-2014
Some rights reserved