What is a named system exception in Oracle?
Named system exceptions are exceptions that have been given names by PL/sql. They are named in the STANDARD package in PL/sql and do not need to be defined by the programmer.
Oracle has a standard set of exceptions already named as follows:
| Oracle Exception Name | Oracle Error | Explanation |
|---|---|---|
| DUP_VAL_ON_INDEX | ORA-00001 | You tried to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique index. |
| TIMEOUT_ON_RESOURCE | ORA-00051 | You were waiting for a resource and you timed out. |
| TRANSACTION_BACKED_OUT | ORA-00061 | The remote portion of a transaction has rolled back. |
| INVALID_CURSOR | ORA-01001 | You tried to reference a cursor that does not yet exist. This may have happened because you've executed a FETCH cursor or CLOSE cursor before opening the cursor. |
| NOT_LOGGED_ON | ORA-01012 | You tried to execute a call to Oracle before logging in. |
| LOGIN_DENIED | ORA-01017 | You tried to log into Oracle with an invalid username/password combination. |
| NO_DATA_FOUND | ORA-01403 | You tried one of the following:
|
| TOO_MANY_ROWS | ORA-01422 | You tried to execute a SELECT INTO statement and more than one row was returned. |
| ZERO_DIVIDE | ORA-01476 | You tried to divide a number by zero. |
| INVALID_NUMBER | ORA-01722 | You tried to execute a sql statement that tried to convert a string to a number,but it was unsuccessful. |
| STORAGE_ERROR | ORA-06500 | You ran out of memory or memory was corrupted. |
| PROGRAM_ERROR | ORA-06501 | This is a generic "Contact Oracle support" message because an internal problem was encountered. |
| VALUE_ERROR | ORA-06502 | You tried to perform an operation and there was a error on a conversion,truncation,or invalid constraining of numeric or character data. |
| CURSOR_ALREADY_OPEN | ORA-06511 | You tried to open a cursor that is already open. |
Oracle PL/sql Exception：http://docs.oracle.com/cd/B10500_01/appdev.920/a96624/07_errs.htm