SEND_ATTACH_VARCHAR2 procedure - Send an e-mail with a VARCHAR attachment to an SMTP server

The SEND_ATTACH_VARCHAR2 procedure provides the capability to send an e-mail to an SMTP server with a text attachment.

Syntax

Read syntax diagramSkip visual syntax diagramUTL_MAIL.SEND_ATTACH_VARCHAR2( sender,recipients,cc ,bcc,subject, message,mime_type, priority,attachment,att_inline,att_mime_type,att_filename)

Parameters

sender
An input argument of type VARCHAR(256) that specifies the e-mail address of the sender.
recipients
An input argument of type VARCHAR(32672) that specifies the comma-separated e-mail addresses of the recipients.
cc
An input argument of type VARCHAR(32672) that specifies the comma-separated e-mail addresses of copy recipients.
bcc
An input argument of type VARCHAR(32672) that specifies the comma-separated e-mail addresses of blind copy recipients.
subject
An input argument of type VARCHAR(32672) that specifies the subject line of the e-mail.
message
An input argument of type VARCHAR(32672) that specifies the body of the e-mail.
mime_type
An input argument of type VARCHAR(1024) that specifies the MIME type of the message. The default is 'text/plain; charset=us-ascii'.
priority
An input argument of type INTEGER that specifies the priority of the e-mail The default value is 3.
attachment
An input argument of type VARCHAR(32000) that contains the attachment.
att_inline
An optional input argument of type BOOLEAN that specifies whether the attachment is viewable inline. If set to "true", then the attachment is viewable inline, "false" otherwise. The default value is "true".
att_mime_type
An optional input argument of type VARCHAR(1024) that specifies the MIME type of the attachment. The default value is 'text/plain; charset=us-ascii'.
att_filename
An optional input argument of type VARCHAR(512) that specifies the file name containing the attachment. The default value is NULL.

Authorization

EXECUTE privilege on the UTL_MAIL module.