3.21 UTL_MAIL

Table of Contents Previous Next


3 Built-In Packages : 3.21 UTL_MAIL

The UTL_MAIL package provides the capability to manage e-mail. Advanced Server supports the following procedures:
SEND(sender, recipients, cc, bcc, subject, message [, mime_type [, priority ]])
SEND_ATTACH_RAW(sender, recipients, cc, bcc, subject, message, mime_type, priority, attachment [, att_inline [, att_mime_type [, att_filename ]]])
Same as the SEND procedure, but with BYTEA or large object attachments.
SEND_ATTACH_VARCHAR2(sender, recipients, cc, bcc, subject, message, mime_type, priority, attachment [, att_inline [, att_mime_type [, att_filename ]]])
Same as the SEND procedure, but with VARCHAR2 attachments.
Note: An administrator must grant execute privileges to each user or group before they can use this package.
3.21.1 SEND
The SEND procedure provides the capability to send an e-mail to an SMTP server.
SEND(sender VARCHAR2, recipients VARCHAR2, cc VARCHAR2,
bcc VARCHAR2, subject VARCHAR2, message VARCHAR2
[, mime_type VARCHAR2 [, priority PLS_INTEGER ]])
Mime type of the message. The default is text/plain; charset=us-ascii.
The SEND_ATTACH_RAW procedure provides the capability to send an e-mail to an SMTP server with an attachment containing either BYTEA data or a large object (identified by the large object's OID). The call to SEND_ATTACH_RAW can be written in two ways:
SEND_ATTACH_RAW(sender VARCHAR2, recipients VARCHAR2,
cc VARCHAR2, bcc VARCHAR2, subject VARCHAR2, message VARCHAR2,
mime_type VARCHAR2, priority PLS_INTEGER,
attachment BYTEA[, att_inline BOOLEAN
[, att_mime_type VARCHAR2[, att_filename VARCHAR2 ]]])
SEND_ATTACH_RAW(sender VARCHAR2, recipients VARCHAR2,
cc VARCHAR2, bcc VARCHAR2, subject VARCHAR2, message VARCHAR2,
mime_type VARCHAR2, priority PLS_INTEGER, attachment OID
[, att_inline BOOLEAN [, att_mime_type VARCHAR2
[, att_filename VARCHAR2 ]]])
Mime type of the message. The default is text/plain; charset=us-ascii.
If set to TRUE, then the attachment is viewable inline, FALSE otherwise. The default is TRUE.
The SEND_ATTACH_VARCHAR2 procedure provides the capability to send an e-mail to an SMTP server with a text attachment.
SEND_ATTACH_VARCHAR2(sender VARCHAR2, recipients VARCHAR2, cc VARCHAR2, bcc VARCHAR2, subject VARCHAR2, message VARCHAR2, mime_type VARCHAR2, priority PLS_INTEGER, attachment VARCHAR2 [, att_inline BOOLEAN [, att_mime_type VARCHAR2 [, att_filename VARCHAR2 ]]])
Mime type of the message. The default is text/plain; charset=us-ascii.
The VARCHAR2 attachment.
If set to TRUE, then the attachment is viewable inline, FALSE otherwise. The default is TRUE.

3 Built-In Packages : 3.21 UTL_MAIL

Table of Contents Previous Next