在哪里可以找到预定义?Oracle pl / SQL完整列表异常?
技术问答
304 人阅读
|
0 人回复
|
2023-09-14
|
在哪里可以找到所有预定义?Oracle pl / SQL完整列表异常?. g9 z' ~3 U1 F Q7 Z5 Q: y& I0 Y7 k
在这个链接中,我找到了这个列表。现在有吗? E% d8 t E/ c
ACCESS_INTO_NULL ORA-06530CASE_NOT_FOUND ORA-06592COLLECTION_IS_NULL ORA-06531CURSOR_ALREADY_OPEN ORA-06511DUP_VAL_ON_INDEX ORA-00001INVALID_CURSOR ORA-01001INVALID_NUMBER ORA-01722LOGIN_DENIED ORA-01017NO_DATA_FOUND ORA-01403NOT_LOGGED_ON ORA-01012PROGRAM_ERROR ORA-06501ROWTYPE_MISMATCH ORA-06504SELF_IS_NULL ORA-30625STORAGE_ERROR ORA-06500SUBSCRIPT_BEYOND_COUNT ORA-06533SUBSCRIPT_OUTSIDE_LIMIT ORA-06532SYS_INVALID_ROWID ORA-01410TIMEOUT_ON_RESOURCE ORA-00051TOO_MANY_ROWS ORA-01422VALUE_ERROR ORA-06502ZERO_DIVIDE ORA-01476 ' E1 ]) ]+ w1 T
解决方案:
6 r) B. {6 I+ ^! q4 Y 这些是针对11gr2.快速扫描表明它们仍然相同:http" c [0 j; O9 M( }0 V& C
:
# |% Y' u5 }; Z//download.oracle.com/docs/cd/E11882_01/appdev.112/e10472/errors.htm#BABHDGGG
' N$ w& \& j- g. H这是来自$ ORACLE_HOME / rdbms / admin / stdspec.sql(egorius标准软件包的要点是找答案的地方)# {+ [& v3 K5 k0 M0 ?1 |
********** Predefined exceptions **********/ CURSOR_ALREADY_OPEN exception; pragma EXCEPTION_INIT(CURSOR_ALREADY_OPEN,'-6511'); DUP_VAL_ON_INDEX exception; pragma EXCEPTION_INIT(DUP_VAL_ON_INDEX,'-0001'); TIMEOUT_ON_RESOURCE exception; pragma EXCEPTION_INIT(TIMEOUT_ON_RESOURCE,'-0051'); INVALID_CURSOR exception; pragma EXCEPTION_INIT(INVALID_CURSOR,'-1001'); NOT_LOGGED_ON exception; pragma EXCEPTION_INIT(NOT_LOGGED_ON,'-1012'); LOGIN_DENIED exception; pragma EXCEPTION_INIT(LOGIN_DENIED,'-1017'); NO_DATA_FOUND exception; pragma EXCEPTION_INIT(NO_DATA_FOUND,100); ZERO_DIVIDE exception; pragma EXCEPTION_INIT(ZERO_DIVIDE,'-1476'); INVALID_NUMBER exception; pragma EXCEPTION_INIT(INVALID_NUMBER,'-1722'); TOO_MANY_ROWS exception; pragma EXCEPTION_INIT(TOO_MANY_ROWS,'-1422'); STORAGE_ERROR exception; pragma EXCEPTION_INIT(STORAGE_ERROR,'-6500'); PROGRAM_ERROR exception; pragma EXCEPTION_INIT(PROGRAM_ERROR,'-6501'); VALUE_ERROR exception; pragma EXCEPTION_INIT(VALUE_ERROR,'-6502'); ACCESS_INTO_NULL exception; pragma EXCEPTION_INIT(ACCESS_INTO_NULL,'-6530'); COLLECTION_IS_NULL exception; pragma EXCEPTION_INIT(COLLECTION_IS_NULL ,'-6531'); SUBSCRIPT_OUTSIDE_LIMIT exception; pragma EXCEPTION_INIT(SUBSCRIPT_OUTSIDE_LIMIT,'-6532'); SUBSCRIPT_BEYOND_COUNT exception; pragma EXCEPTION_INIT(SUBSCRIPT_BEYOND_COUNT ,'-6533'); -- exception for ref cursors ROWTYPE_MISMATCH exception; pragma EXCEPTION_INIT(ROWTYPE_MISMATCH,'-6504'); SYS_INVALID_ROWID EXCEPTION; PRAGMA EXCEPTION_INIT(SYS_INVALID_ROWID,'-1410'); -- The object instance i.e. SELF is null SELF_IS_NULL exception; pragma EXCEPTION_INIT(SELF_IS_NULL,'-30625'); CASE_NOT_FOUND exception; pragma EXCEPTION_INIT(CASE_NOT_FOUND,'-6592'); -- Added for USERENV enhancement,bug 1622213. USERENV_COMMITSCN_ERROR exception; pragma EXCEPTION_INIT(USERENV_COMMITSCN_ERROR,'-1725'); -- Parallel and pipelined support NO_DATA_NEEDED exception; pragma EXCEPTION_INIT(NO_DATA_NEEDED,'-6548'); -- End of 8.2 parallel and pipelined support /********** Add new exceptions here ********** |
|
|
|
|
|