在哪里可以找到预定义？Oracle pl / SQL完整列表异常？
技术问答
142 人阅读
|
0 人回复
|
2023-09-14
|
|
在哪里可以找到所有预定义？Oracle pl / SQL完整列表异常？# ~$ s) |- `) A; z# }# w
在这个链接中，我找到了这个列表。现在有吗？
! @% B& I k- L: B2 aACCESS_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
v# R# C- ]5 d" P' m2 _ 解决方案:
1 O+ C+ d+ C$ b4 Z1 A3 g; O6 X. t 这些是针对11gr2.快速扫描表明它们仍然相同：http- B9 N: [2 W# f. [
:" w) K# q0 j- R" f% F% P$ E# X# A$ c
//download.oracle.com/docs/cd/E11882_01/appdev.112/e10472/errors.htm#BABHDGGG
) ~1 X: k5 ]; j& b! j这是来自$ ORACLE_HOME / rdbms / admin / stdspec.sql（egorius标准软件包的要点是找答案的地方)8 W. r* h: [2 P C
********** 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 ********** |
|
|
|
|
|
|
|
|
|
