| 24. 14. 7. Understanding Different Exception Types |
|
|
Identifying Exception Types |
| Error Code Prefix | Indicates This Exception Type of Error | | ORA | Core RDBMS errors | | PLS | PL/SQL errors | | FRM | Oracle Forms errors | | REP | Oracle 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. |