简单列一下常用的吧：
|
异常名
|
异常标题
|
异常号
|
|
ACCESS_INTO_NULL
|
ORA-06530
|
-6530
|
|
CASE_NOT_FOUND
|
ORA-06592
|
-6592
|
|
COLLECTION_IS_NULL
|
ORA-06531
|
-6531
|
|
CURSOR_ALREADY_OPEN
|
ORA-06511
|
-6511
|
|
DUP_VAL_ON_INDEX
|
ORA-00001
|
-1
|
|
INVALID_CURSOR
|
ORA-01001
|
-1001
|
|
INVALID_NUMBER
|
ORA-01722
|
-1722
|
|
LOGIN_DENIED
|
ORA-01017
|
-1017
|
|
NO_DATA_FOUND
|
ORA-01403
|
-1403
|
|
NOT_LOGGED_ON
|
ORA-01012
|
-1012
|
|
PROGRAM_ERROR
|
ORA-06501
|
-6501
|
|
ROWTYPE_MISMATCH
|
ORA-06504
|
-6504
|
|
SELF_IS_NULL
|
ORA-30625
|
-30625
|
|
STORAGE_ERROR
|
ORA-06500
|
-6500
|
|
SUBSCRIPT_BEYOND_COUNT
|
ORA-06533
|
-6533
|
|
SUBSCRIPT_OUTSIDE_LIMIT
|
ORA-06532
|
-6532
|
|
SYS_INVALID_ROWID
|
ORA-01410
|
-1410
|
|
TIMEOUT_ON_RESOURCE
|
ORA-00051
|
-51
|
|
TOO_MANY_ROWS
|
ORA-01422
|
-1422
|
|
VALUE_ERROR
|
ORA-06502
|
-6502
|
|
ZERO_DIVIDE
|
ORA-01476
|
-1476
|
以上异常说明：
|
异常名
|
说明
|
|
ACCESS_INTO_NULL
|
试图给一个没有初始化的对象赋值
|
|
CASE_NOT_FOUND
|
在case语句中没有WHEN子句被选择，并且没有ELSE子句
|
|
COLLECTION_IS_NULL
|
试图将EXISTS以外的集合（collection）方法应到到一个没有被初始化的嵌套表（nested table）和变长数组（varray）中，或者试图 给没有初始化的嵌套表或变长数组中的原素赋值
|
|
CURSOR_ALREADY_OPEN
|
试图打开一个已经代开的游标。一个游标FOR循环会自动打开所涉及的游标，所以在游标循环中不能打开游标
|
|
DUP_VAL_ON_INDEX
|
主键冲突
|
|
INVALID_CURSOR
|
试图执行一个无效的游标操作
|
|
INVALID_NUMBER
|
在sql语句中，数字转化错误
|
|
LOGIN_DENIED
|
无效的用户名或口令去登录
|
|
NO_DATA_FOUND
|
SELECT INTO 没有返回结果。或者程序引用一个嵌套表中被删除的原素或索引表中一个没有被初始化的元素
|
|
NOT_LOGGED_ON
|
没有链接到数据库
|
|
PROGRAM_ERROR
|
PL/SQL has an internal problem.
|
|
ROWTYPE_MISMATCH
|
The host cursor variable and PL/SQL cursor variable involved in an assignment have incompatible return types. For example, when an open host cursor variable is passed to a stored subprogram, the return types of the actual and formal parameters must be compatible.
|
|
SELF_IS_NULL
|
Your program attempts to call a MEMBER method on a null instance. That is, the built-in parameter SELF (which is always the first parameter passed to a MEMBER method) is null.
|
|
STORAGE_ERROR
|
PL/SQL runs out of memory or memory has been corrupted.
|
|
SUBSCRIPT_BEYOND_COUNT
|
Your program references a nested table or varray element using an index number larger than the number of elements in the collection.
|
|
SUBSCRIPT_OUTSIDE_LIMIT
|
Your program references a nested table or varray element using an index number (-1 for example) that is outside the legal range.
|
|
SYS_INVALID_ROWID
|
The conversion of a character st*** into a universal rowid fails because the character st*** does not represent a valid rowid.
|
|
TIMEOUT_ON_RESOURCE
|
A time-out occurs while Oracle is waiting for a resource.
|
|
TOO_MANY_ROWS
|
A SELECT INTO statement returns more than one row.
|
|
VALUE_ERROR
|
An arithmetic, conversion, truncation, or size-constraint error occurs. For example, when your program selects a column value into a character variable, if the value is longer than the declared length of the variable, PL/SQL aborts the assignment and raises VALUE_ERROR. In procedural statements, VALUE_ERROR is raised if the conversion of a character st*** into a number fails. (In SQL statements, INVALID_NUMBER is raised.)
|
|
ZERO_DIVIDE
|
Your program attempts to divide a number by zero
|
posted on 2007-06-22 15:08
汪伟 阅读(76)
评论(0) 编辑 收藏