Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Mailing to a user if my stored procedure fails/exe

Author  Topic 

Srinivas.Chebolu
Starting Member

4 Posts

Posted - 2001-10-12 : 11:06:29
Hi,

I have a query...

Say i have a stored procedure Proc_X

Now if my Proc_X executes i need to send mail to a user.If it fails i needs to send a mail to the administrator with the error as the body of the mail.

1.How can i do this?Does Oracle support this.

2.I have oracle 8i.What modules in it need to be active if i need to send the mails.

3.Can some one provide me with any link which gives more information on how such functionality if exists works.

Please throw some light on the above.

Thanks and Regards
Srinivas Chebolu


   

- Advertisement -