Dear community.
I’d like to create a custom event that will be triggered if someone attempts to perform an action that is not allowed by the PLSQL rules. I will use Error_SYS.Record_General to display an error message and perform a hard stop.
I would like to be able to also trigger an email at this point to a user to let them know that someone tried to perform the action.
The problem i am finding is that the Error_SYS.Record_General stops the commit transaction and also the email that is generate by COMMAND_SYS.Mail.
I was thinking of using exception handling etc to get this to work but so far have been unable to. Same goes for creating a second event action, since the Error_sys stops the transaction this didnt appear to work for me either.
Anyone have any bright ideas?
Many thanks,
David.
Best answer by EntShehaM
View original