Oralce数据库常用预定义例外：EXCEPTIONWHEN CURSOR_ALREADY_OPEN THEN-- ORA-06511 SQLCODE = -6511 游标已经打开WHEN DUP_VAL_ON_INDEX THEN-- ORA-00001 SQLCODE = -1 向唯一索引中插入重复数据WHEN INVALID_CURSOR THEN-- ORA-01001 SQLCODE = -1001 非法游标操作WHEN INVALID_NUMBER THEN-- ORA-01722 SQLCODE = -1722 字符向数字转换失败WHEN LOGIN_DENIED THEN-- ORA-01017 SQLCODE = -1017WHEN NO_DATA_FOUND THEN-- ORA-01403 SQLCODE = 100 没有找到数据WHEN NOT_LOGGED_ON THEN-- ORA-01012 SQLCODE = -1012WHEN PROGRAM_ERROR THEN-- ORA-06501 SQLCODE = -6501 程序错误WHEN STORAGE_ERROR THEN-- ORA-06500 SQLCODE = -6500WHEN TIMEOUT_ON_RESOURCE THEN-- ORA-00051 SQLCODE = -51WHEN TOO_MANY_ROWS THEN-- ORA-01422 SQLCODE = -1422 返回多行WHEN TRANSACTION_BACKED_OUT THEN-- ORA-00061 SQLCODE = -61WHEN VALUE_ERROR THEN-- ORA-06502 SQLCODE = -6502 数值转换错误WHEN ZERO_DIVIDE THEN-- ORA-01476 SQLCODE = -1476 被零除WHEN OTHERS THEN-- 其它任何错误的处理END;--用户定义的例外DECLAREFIND_DATA_EMP EXCEPTION;BEGINIF ... THENRAISE FIND_DATA_EMP;END IF;EXCEPTIONWHEN LOB_NO_LOCKED THEN...END;Ubuntu上的MySQL字符集设置技巧Linux系统中卸载Netbackup相关资讯 Oralce数据库 本文评论 查看全部评论 （0）
易网时代-编程资源站