| HELP!! Alerting DBA from a stored procedure [message #69131] |
Mon, 05 November 2001 17:38  |
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  |
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
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
