Getting error codes and error descriptions
727837Oct 14 2009 — edited Oct 14 2009I was wondering if there was a way to retrieve error codes and do something like, say, store them in a variable. For example, when you have a log on error you will get the message "ORA-0107" and the description "Invalid user name/password".
I am aiming to use a trigger to fire every time an error occurs, at the same time storing the code of the error (and the description) into a variable.
I appreciate any help.