Home » RDBMS Server » Server Utilities » HELP!! Alerting DBA from a stored procedure
HELP!! Alerting DBA from a stored procedure [message #69131] Mon, 05 November 2001 17:38 Go to next message
Haley
Messages: 1
Registered: November 2001
Junior Member
I need to find a way to send out an email if an error occurs. Right now, my Procedure inserts all exception cases into Exceptions table. IF there is any error, then the procedure needs to send out an email to the production support. IF there was no error, then no email should be sent out. I know that there is a way to send out an email in kshell. But I don't know how to pass the error message to kshell from SQL procedure. Any ideas??

----------------------------------------------------------------------
Re: HELP!! Alerting DBA from a stored procedure [message #69135 is a reply to message #69131] Tue, 06 November 2001 05:41 Go to previous message
oraboy
Messages: 97
Registered: October 2001
Member
Now Oracle has built-in UTL_SMTP package for sending mails (so dont bother about shell)
And since its purely PL/SQL , its easy to use and rewrite it later.

Regards
oraboy

----------------------------------------------------------------------
Previous Topic: INDEX and Export-Import
Next Topic: To know details of your activities and on ORACLE U provide
Goto Forum:
  


Current Time: Fri Mar 29 04:28:57 CDT 2024