Identifying Exception Types
Error Code PrefixIndicates This Exception Type of Error
ORACore RDBMS errors
PLSPL/SQL errors
FRMOracle Forms errors
REPOracle Reports errors
Oracle function SQLCODE returns the type and code of the most recently raised exception.
Exception names are usually associated with exceptions that you create yourself.
The exception message is a text string that describes the exception.
The function SQLERRM returns the text of the error message for the most recently raised exception.