Oracle认证：解析Oralce数据库常用预定义的例外

会计考友

Oralce数据库常用预定义例外：
EXCEPTION
: y0 Z; y8 v- SWHEN CURSOR_ALREADY_OPEN THEN-- ORA-06511 SQLCODE = -6511 游标已经打开

WHEN DUP_VAL_ON_INDEX THEN
-- ORA-00001 SQLCODE = -1 向唯一索引中插入重复数据
  V# N- l/ _6 P* s: k0 _8 s% P
. a, G( D$ V1 vWHEN INVALID_CURSOR THEN
" V1 t4 O/ W6 \- ^0 n5 P-- ORA-01001 SQLCODE = -1001 非法游标操作
' N; S. h* W; v
WHEN INVALID_NUMBER THEN-- ORA-01722 SQLCODE = -1722 字符向数字转换失败

WHEN LOGIN_DENIED THEN
-- ORA-01017 SQLCODE = -1017

WHEN NO_DATA_FOUND THEN
-- ORA-01403 SQLCODE = +100 没有找到数据
: }1 w0 P" v3 p9 P
" f0 H  }- i- ^+ j9 D2 c4 P3 K0 ]8 ?WHEN NOT_LOGGED_ON THEN
! o* f7 X; h8 ^% D3 i' G-- ORA-01012 SQLCODE = -1012
1 \4 G1 }) E, U! V( q. I' }  |3 W
WHEN PROGRAM_ERROR THEN
-- ORA-06501 SQLCODE = -6501 程序错误

. Y+ q0 t( E: X, [. Y, j& K0 cWHEN STORAGE_ERROR THEN
-- ORA-06500 SQLCODE = -6500

WHEN TIMEOUT_ON_RESOURCE THEN
-- ORA-00051 SQLCODE = -51

0 m. w4 n5 R- e" j& `WHEN TOO_MANY_ROWS THEN-- ORA-01422 SQLCODE = -1422 返回多行
  z+ |) \1 J8 m6 U9 B  [
, l9 S8 ^& k9 ^2 A5 S9 E( mWHEN TRANSACTION_BACKED_OUT THEN
-- ORA-00061 SQLCODE = -61

WHEN VALUE_ERROR THEN
-- ORA-06502 SQLCODE = -6502 数值转换错误
4 t+ E7 [: D$ Q2 b
/ v" z) }( J% r; S+ OWHEN ZERO_DIVIDE THEN
+ |/ z' o% p' a3 Y+ U-- ORA-01476 SQLCODE = -1476 被零除

WHEN OTHERS THEN-- 其它任何错误的处理

END;
+ `" ?( z- W8 ^: R$ L4 S
+ }7 ~/ n  i* w4 F% _, k: Q+ J9 H--用户定义的例外
DECLARE
2 P2 h* }! Z3 h" q1 ?4 M7 HFIND_DATA_EMP EXCEPTION;
, o& b. L3 c# S6 w" ?! @BEGIN
+ v. R' c9 I5 ~" ~1 ~9 lIF ... THEN
* e5 C# W# S7 B- v& nRAISE FIND_DATA_EMP;
END IF;
EXCEPTION
WHEN LOB_NO_LOCKED THEN
* Y7 X( d( m5 Z! g8 d& M... END;