The UTL_MAIL
package is a utility for managing email which includes commonly used email features, such as attachments, CC, BCC, and return receipt.
This chapter contains the following topics:
Security Model
Operational Notes
UTL_MAIL
is not installed by default because of the SMTP_OUT_SERVER
configuration requirement and the security exposure this involves. In installing UTL_MAIL
, you should take steps to prevent the port defined by SMTP_OUT_SERVER
being swamped by data transmissions.
You must both install UTL_MAIL
and define the SMTP_OUT_SERVER.
To install UTL_MAIL:
sqlplus sys/<pwd> SQL> @$ORACLE_HOME/rdbms/admin/utlmail.sql SQL> @$ORACLE_HOME/rdbms/admin/prvtmail.plb
You define the SMTP_OUT_SERVER
parameter in the init
.ora
rdbms
initialization file. However, if SMTP_OUT_SERVER
is not defined, this invokes a default of DB_DOMAIN
which is guaranteed to be defined to perform appropriately.
Table 173-1 UTL_MAIL Package Subprograms
Subprogram | Description |
---|---|
Packages an email message into the appropriate format, locates SMTP information, and delivers the message to the SMTP server for forwarding to the recipients |
|
Represents the |
|
Represents the |
This procedure packages an email message into the appropriate format, locates SMTP information, and delivers the message to the SMTP server for forwarding to the recipients. It hides the SMTP API and exposes a one-line email facility for ease of use.
UTL_MAIL.SEND ( sender IN VARCHAR2 CHARACTER SET ANY_CS, recipients IN VARCHAR2 CHARACTER SET ANY_CS, cc IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL, bcc IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL, subject IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL, message IN VARCHAR2 CHARACTER SET ANY_CS, mime_type IN VARCHAR2 DEFAULT 'text/plain; charset=us-ascii', priority IN PLS_INTEGER DEFAULT NULL);
Table 173-2 SEND Procedure Parameters
Parameter | Description |
---|---|
|
The email address of the sender. |
|
The email addresses of the recipient(s), separated by commas. |
|
The email addresses of the CC recipient(s), separated by commas, default is |
|
The email addresses of the BCC recipient(s), separated by commas, default is |
|
A string to be included as email subject string, default is |
|
A text message body. |
|
The mime type of the message, default is 'text/plain; charset=us-ascii' |
|
The message priority, default is |
This procedure is the SEND
Procedure overloaded for RAW
attachments.
UTL_MAIL.SEND_ATTACH_RAW ( sender IN VARCHAR2 CHARACTER SET ANY_CS, recipients IN VARCHAR2 CHARACTER SET ANY_CS, cc IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL, bcc IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL, subject IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL, message IN VARCHAR2 CHARACTER SET ANY_CS, mime_type IN VARCHAR2 DEFAULT 'text/plain; charset=us-ascii', priority IN PLS_INTEGER DEFAULT NULL attachment IN RAW, att_inline IN BOOLEAN DEFAULT TRUE, att_mime_type IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT 'application/octet', att_filename IN VARCHAR2 DEFAULT NULL);
Table 173-3 SEND_ATTACH_RAW Procedure Parameters
Parameter | Description |
---|---|
|
The email address of the sender. |
|
The email addresses of the recipient(s), separated by commas. |
|
The email addresses of the CC recipient(s), separated by commas, default is |
|
The email addresses of the BCC recipient(s), separated by commas, default is |
|
A string to be included as email subject string, default is |
|
A text message body. |
|
The mime type of the message, default is 'text/plain; charset=us-ascii'. |
|
The message priority, the default is |
|
A |
|
Specifies whether the attachment is viewable inline with the message body, default is |
|
The mime type of the attachment, default is 'application/octet'. |
|
The string specifying a filename containing the attachment, default is |
This procedure is the SEND
Procedure overloaded for VARCHAR2
attachments.
UTL_MAIL.SEND_ATTACH_VARCHAR2 ( sender IN VARCHAR2 CHARACTER SET ANY_CS, recipients IN VARCHAR2 CHARACTER SET ANY_CS, cc IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL, bcc IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL, subject IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL, message IN VARCHAR2 CHARACTER SET ANY_CS, mime_type IN VARCHAR2 DEFAULT 'text/plain; charset=us-ascii', priority IN PLS_INTEGER DEFAULT NULL attachment IN RAW, att_inline IN BOOLEAN DEFAULT TRUE, att_mime_type IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT 'application/octet', att_filename IN VARCHAR2 DEFAULT NULL);
Table 173-4 SEND_ATTACH_VARCHAR2 Procedure Parameters
Parameter | Description |
---|---|
|
The email address of the sender. |
|
The email addresses of the recipient(s), separated by commas. |
|
The email addresses of the CC recipient(s), separated by commas, default is |
|
The email addresses of the BCC recipient(s), separated by commas, default is |
|
A string to be included as email subject string, default is |
|
A text message body. |
|
The mime type of the message, default is 'text/plain; charset=us-ascii'. |
|
The message priority, the default is |
|
A text attachment. |
|
Specifies whether the attachment is inline, default |
|
The mime type of the attachment, default is 'text/plain; charset=us-ascii'. |
|
The string specifying a filename containing the attachment, default is |