UTL_SMTP - email through store proc

[Kumud]

I want to send email whenever exception in my store proce which runs every night.
does any body has used UTL_SMTL, UTL_TCP .... ?
Please guide me or is there any other way for notifivation via email if data inserted in error_log table...


Thanks in advance

[santoshym]

Hi

Try this link

http://asktom.oracle.com/pls/ask/f?p...0_P8_DISPLAYID

You can also search

asktom.oracle.com

Will get all answers

Regards

[kris109]

We are developing a email system using UTL_SMTP that sends reports every day and actually looking into these issues right now.

[TimHall]

This should work fine in 8i aswell as 9i:

http://www.oracle-base.com/Articles/...romPLSQL9i.asp

Cheers

[VladZak]

You can try our PSP_Mail product which is built on top of UTL_SMTP and provides a simple interface for sending various types of email, including email with any number of LOBs or OS files as attachments. The package can do DNS lookups and send mail directly to the mail server of recipient or it can route all mail through your local mail relay server, you can encode message text and headers using Base64 encoding to preserve national language, you can target multiple recipients in one call (using To: , Cc: and Bcc: headers) and much more. Low-level interface is also provided which hands the task of message generation over to the caller and provides only transport for message delivery. And you don't need to load JavaMail or setup any external scripts or procedures for this.
Download your evaluation copy at http://www.dpsp-yes.com.

hth,
Bob.