Skip Headers
Oracle® Database PL/SQL Packages and Types Reference
11g Release 2 (11.2)

Part Number E25788-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub
ARPLS384

229 UTL_MAIL

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

This chapter contains the following topics:

ARPLS71198

Using UTL_MAIL

ARPLS71199

Security Model

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.

This package is now an invoker's rights package and the invoking user will need the connect privilege granted in the access control list assigned to the remote network host to which he wants to connect.

ARPLS71200

Operational Notes

You must both install UTL_MAIL and define the SMTP_OUT_SERVER.

sqlplus sys/<pwd>
SQL> @$ORACLE_HOME/rdbms/admin/utlmail.sql
SQL> @$ORACLE_HOME/rdbms/admin/prvtmail.plb
ARPLS71201

Rules and Limits

Use UTL_MAIL only within the context of the ASCII (American Standard Code for Information Interchange) and EBCDIC (Extended Binary-Coded Decimal Interchange Code) codes.

ARPLS71202

Summary of UTL_MAIL Subprograms

ARPLS71203Table 229-1 UTL_MAIL Package Subprograms

Subprogram Description

SEND 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

SEND_ATTACH_RAW Procedure

Represents the SEND Procedure overloaded for RAW attachments

SEND_ATTACH_VARCHAR2 Procedure

Represents the SEND Procedure overloaded for VARCHAR2 attachments


ARPLS71204

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.

Syntax

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);

Parameters

ARPLS71205Table 229-2 SEND Procedure Parameters

Parameter Description

sender

Email address of the sender

recipients

Email addresses of the recipient(s), separated by commas

cc

Email addresses of the CC recipient(s), separated by commas, default is NULL

bcc

Email addresses of the BCC recipient(s), separated by commas, default is NULL

subject

String to be included as email subject string, default is NULL

message

Text message body

mime_type

Mime type of the message, default is 'text/plain; charset=us-ascii'

priority

Message priority, which maps to the X-priority field. 1 is the highest priority and 5 the lowest. The default is 3.

replyto

Defines to whom the reply email is to be sent


ARPLS71206

SEND_ATTACH_RAW Procedure

This procedure is the SEND Procedure overloaded for RAW attachments.

Syntax

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 DEFAULT NULL,
   mime_type        IN    VARCHAR2 DEFAULT CHARACTER SET ANY_CS
                              DEFAULT 'text/plain; charset=us-ascii',
   priority         IN    PLS_INTEGER DEFAULT 3,
   attachment       IN    RAW,
   att_inline       IN    BOOLEAN DEFAULT TRUE,
   att_mime_type    IN    VARCHAR2 CHARACTER SET ANY_CS 
                                           DEFAULT 'text/plain; charset=us-ascii',
   att_filename     IN    VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL,
   replyto          IN    VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL);

Parameters

ARPLS71207Table 229-3 SEND_ATTACH_RAW Procedure Parameters

Parameter Description

sender

Email address of the sender

recipients

Email addresses of the recipient(s), separated by commas

cc

Email addresses of the CC recipient(s), separated by commas, default is NULL

bcc

Email addresses of the BCC recipient(s), separated by commas, default is NULL

subject

String to be included as email subject string, default is NULL

message

Text message body

mime_type

Mime type of the message, default is 'text/plain; charset=us-ascii'

priority

Message priority, which maps to the X-priority field. 1 is the highest priority and 5 the lowest. The default is 3.

attachment

RAW attachment

att_inline

Specifies whether the attachment is viewable inline with the message body, default is TRUE

att_mime_type

Mime type of the attachment, default is 'application/octet'

att_filename

String specifying a filename containing the attachment, default is NULL

replyto

Defines to whom the reply email is to be sent


ARPLS71208

SEND_ATTACH_VARCHAR2 Procedure

This procedure is the SEND Procedure overloaded for VARCHAR2 attachments.

Syntax

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 DEFAULT NULL,
   mime_type         IN    VARCHAR2 CHARACTER SET ANY_CS 
                                           DEFAULT 'text/plain; charset=us-ascii',
   priority          IN    PLS_INTEGER DEFAULT 3,
   attachment        IN    VARCHAR2 CHARACTER SET ANY_CS, ,
   att_inline        IN    BOOLEAN DEFAULT TRUE,
   att_mime_type     IN    VARCHAR2 CHARACTER SET ANY_CS 
                                           DEFAULT 'text/plain; charset=us-ascii,
   att_filename      IN    VARCHAR2CHARACTER SET ANY_CS DEFAULT NULL,
   replyto           IN    VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL);

Parameters

ARPLS71209Table 229-4 SEND_ATTACH_VARCHAR2 Procedure Parameters

Parameter Description

sender

Email address of the sender

recipients

Email addresses of the recipient(s), separated by commas

cc

Email addresses of the CC recipient(s), separated by commas, default is NULL

bcc

Email addresses of the BCC recipient(s), separated by commas, default is NULL

subject

String to be included as email subject string, default is NULL

message

Text message body

mime_type

Mime type of the message, default is 'text/plain; charset=us-ascii

priority

Message priority, which maps to the X-priority field. 1 is the highest priority and 5 the lowest. The default is 3.

attachment

Text attachment

att_inline

Specifies whether the attachment is inline, default TRUE

att_mime_type

Mime type of the attachment, default is 'text/plain; charset=us-ascii'

att_filename

String specifying a filename containing the attachment, default is NULL

replyto

Defines to whom the reply email is to be sent


Reader Comment

   

Comments, corrections, and suggestions are forwarded to authors every week. By submitting, you confirm you agree to the terms and conditions. Use the OTN forums for product questions. For support or consulting, file a service request through My Oracle Support.

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

This Page

This Document

New and changed documents:
RSS Feed HTML RSS Feed PDF