UTL_MAIL

The UTL_MAIL package is a utility for managing email which includes commonly used email features, such as attachments, CC, and BCC.

SEND Procedure

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 3,

   replyto     IN    VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL);

SEND_ATTACH_RAW Procedure

This procedure is the SEND Procedure overloaded for RAW attachments

SEND_ATTACH_VARCHAR2 Procedure

This procedure is the SEND Procedure overloaded for VARCHAR2 attachments.