I have couple stored procedures and a package.
Whenever this stored procedure and package goes invalid, I need to send an email.
How can I achieve this?
Can you please give me an idea how this can be done.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
The scope of this question requires some work on your part but as a rough guide:
Edit: the original poster asks how to track incidents. More information is needed such, Oracle version, what kind of incidents, how often do you want to receive notifications.