[Lone solitary Nine swords] Oracle Knowledge Point Grooming (eight) common exception

Link navigation in this series:

[Lone solitary Nine swords] Oracle Knowledge Point Grooming (a) table space, user

[Lone solitary Nine swords] Oracle Knowledge Point Grooming (ii) connection of databases

[Lone solitary Nine swords] Oracle Knowledge Point Grooming (iii) Import, export

[Lone solitary Nine swords] Oracle Knowledge Point Grooming (iv) DML and DDL for SQL statements

[Lone solitary Nine swords] Oracle Knowledge Point Grooming (v) table, View of common objects in database

[Lone solitary Nine swords] Oracle Knowledge Point Grooming (vi) procedure, function and Sequence of common objects in database

[Lone solitary Nine swords] Oracle Knowledge Point Grooming (vii) Cursor of common objects in database

[Lone solitary Nine swords] Oracle Knowledge Point Grooming (eight) common exception

[Lone solitary Nine swords] Oracle Knowledge Point Grooming (ix) database common objects of the package

[Lone solitary Nine swords] Oracle Knowledge Point Grooming (10)%type and%rowtype and common functions

5.7. Common exception

Error name error code error meaning

1. Cursor_already_open ora_06511 attempt to open a cursor that is already open

2. Invalid_cursor ora_01001 attempt to use a cursor that is not open

3. Dup_val_on_index ora_00001 Save duplicate values to a column in a unique index constraint

4, Zero_divide ora_01476 division error occurs with a divisor of zero

5. Invalid_number ora_01722 attempts to convert invalid characters numerically

6, Rowtype_mismatch ora_06504 The type of main variable and cursor is incompatible

7. Error Value_error ora_06502 conversion, truncation, or arithmetic operation

8. Too_many_rows ora_01422 SELECT ... Into ... Statement returns more than one row of data

9. No_data_found ora_01403 SELECT ... Into ... Statement No data returned

10. Timeout error when Timeout_on_resource ora_00051 waiting for resource

11, Transaction_backed_out ora_00060 due to deadlock, the submission failed

12, Storage_Error ora_06500 memory error occurred

13. Program_error ora_06501 a PL/SQL internal error occurred

14. not_logged_on ora_01012 trying to manipulate an disconnected database

15. Login_denied ora_01017 provides invalid user name or password when connecting

　　When dealing with procedure or function internal anomalies, you can do different processing according to the exception category above, lest there is a others then ...

[Lone solitary Nine swords] Oracle Knowledge Point Grooming (eight) common exception