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