|
|
在哪里可以找到所有预定义？Oracle pl / SQL完整列表异常？
5 `! d: R5 `6 A% R0 Q6 e在这个链接中，我找到了这个列表。现在有吗？
# z8 i: O8 d) L( D& c" GACCESS_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 " Z8 B8 g: w) E8 z
解决方案:
- r- H5 Y" o- b) t) D9 I 这些是针对11gr2.快速扫描表明它们仍然相同：http2 z* C9 S, T5 Y. ~& j! L
:# y5 ^4 A1 K4 G7 C' b4 B' D
//download.oracle.com/docs/cd/E11882_01/appdev.112/e10472/errors.htm#BABHDGGG5 S; Z- I7 y9 Q: s
这是来自$ ORACLE_HOME / rdbms / admin / stdspec.sql（egorius标准软件包的要点是找答案的地方)
7 r% H/ w& ?8 l. A ********** 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 ********** |
|
技术问答
263 人阅读
|
0 人回复
|
2023-09-14
