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
Try this link
You can also search
Will get all answers
We are developing a email system using UTL_SMTP that sends reports every day and actually looking into these issues right now.
Remember the Golden Rule - He who has the gold makes the rules!
Ph.D., OCP 8i, 9i, 10g, 11g DBA
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.
Click Here to Expand Forum to Full Width