DB2 Version 9.7 for Linux, UNIX, and Windows

SEND_ATTACH_RAW procedure - Send an email with a BLOB attachment to an SMTP server

The SEND_ATTACH_RAW procedure provides the capability to send an email to an SMTP server with a binary attachment.

Syntax


>>-UTL_MAIL.SEND_ATTACH_RAW--(--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 email address of the sender.
recipients: An input argument of type VARCHAR(32672) that specifies the comma-separated email addresses of the recipients.
cc: An input argument of type VARCHAR(32672) that specifies the comma-separated email addresses of copy recipients.
bcc: An input argument of type VARCHAR(32672) that specifies the comma-separated email addresses of blind copy recipients.
subject: An input argument of type VARCHAR(32672) that specifies the subject line of the email.
message: An input argument of type VARCHAR(32672) that specifies the body of the email.
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 email The default value is 3.
attachment: An input argument of type BLOB(10M) 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 application/octet.
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.