UTL_MAIL
The UTL_MAIL package provides a simple API to allow email to be sent from PL/SQL. The package is loaded by running the following scripts.
CONN sys/password AS SYSDBA
@$ORACLE_HOME/rdbms/admin/utlmail.sql
@$ORACLE_HOME/rdbms/admin/prvtmail.plb
In addition the SMTP_OUT_SERVER parameter must be set to identify the SMTP server.
ALTER SYSTEM SET smtp_out_server='smtp.domain.com:port' SCOPE=SPFILE;
With the configuration complete we can now send a mail.
BEGIN
UTL_MAIL.send(sender => 'me@domain.com',
recipients => 'person1@domain.com,person2@domain.com',
cc => 'person3@domain.com',
bcc => 'myboss@domain.com',
subject => 'UTL_MAIL Test',
message => 'If you get this message it worked!');
END;
/
The package also supports sending mails with RAW and VARCHAR2 attachments.
Fabio
December 27, 2011 at 4:53 pm
Useful article.
Thanks