Exceptions are identified by type, code, name, and error message.
Exception types can be identified by the error code prefixes as outlined in the following table.
|Error Code Prefix||Indicates This Exception Type of Error|
|ORA||Core RDBMS errors|
|FRM||Oracle Forms errors|
|REP||Oracle Reports errors|
Exception codes are negative and are always displayed with five digits.
The code, along with the exception type, uniquely defines the exception.
The Oracle function SQLCODE returns the type and code of the most recently raised exception.
Exception names are associated with exceptions that you create yourself.
If the exception is named, you can use its name in the exception handler.
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.