回答

收藏

在哪里可以找到预定义?Oracle pl / SQL完整列表异常?

技术问答 技术问答 139 人阅读 | 0 人回复 | 2023-09-14

在哪里可以找到所有预定义?Oracle pl / SQL完整列表异常?
0 I8 t* u5 P) @+ A在这个链接中,我找到了这个列表。现在有吗?+ e2 M  m7 s0 ]6 e9 u0 O
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                           - V5 o" [" P9 F- `9 d0 ]
    解决方案:                                                               
$ j8 p( c2 s: r; E5 W1 |$ f7 b* A- W- v                                                                这些是针对11gr2.快速扫描表明它们仍然相同:http0 A  e5 ~7 X" S4 D* H
:
/ L; W4 x( m! K, K) K//download.oracle.com/docs/cd/E11882_01/appdev.112/e10472/errors.htm#BABHDGGG2 \. [/ z# ^. ~. `8 Z) r7 [
这是来自$ ORACLE_HOME / rdbms / admin / stdspec.sql(egorius标准软件包的要点是找答案的地方)
9 P9 R$ W* K" q                        ********** 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 **********
分享到:
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则