Sunday, March 30, 2014

Concurrent program whose output has to be sent as an Email

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.
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,
   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);
SEND_ATTACH_VARCHAR2 Procedure Parameters
ParameterDescription
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

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...