how to send email when the status of the object gets invalid?
I have couple of 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 u pls give me an idea how this can be done