we can send concurrent program out put as email by usingg utl_mail.send_attach_varchar2 producer
SEND_ATTACH_VARCHAR2 Procedure
This procedure is the
SEND
Procedure overloaded for VARCHAR2
attachments.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, mime_type IN VARCHAR2 DEFAULT 'text/plain; charset=us-ascii', priority IN PLS_INTEGER DEFAULT NULL attachment IN RAW, att_inline IN BOOLEAN DEFAULT TRUE, att_mime_type IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT 'application/octet', att_filename IN VARCHAR2 DEFAULT NULL);
Parameter | Description |
---|---|
sender |
The email address of the sender.
|
recipients |
The email addresses of the recipient(s), separated by commas.
|
cc |
The email addresses of the CC recipient(s), separated by commas, default is
NULL . |
bcc |
The email addresses of the BCC recipient(s), separated by commas, default is
NULL. |
subject |
A string to be included as email subject string, default is
NULL. |
message |
A text message body.
|
mime_type |
The mime type of the message, default is 'text/plain; charset=us-ascii'.
|
priority |
The message priority, the default is
NULL. |
attachment |
A text attachment.
|
att_inline |
Specifies whether the attachment is inline, default
TRUE . |
att_mime_type |
The mime type of the attachment, default is 'text/plain; charset=us-ascii'.
|
att_filename |
The string specifying a filename containing the attachment, default is
NULL . |
No comments:
Post a Comment