摘要: 1、自定义异常DECLARE <condition-name> CONDITION FOR SQLSTATE <sqlstate-value>;注:<sqlstate-value>可以从7-9或T-Z开头2、异常捕捉DECLARE EXIT | CONTINUE | UNDOHANDLER FOR 异常 | SQLSTATE <sqlstate-value>BEGINGET DIAGNOSTICS EXCEPTION 1 SQLERRM = MESSAGE_TEXT;-- 取得错误信息VALUES (SQLCODE, SQLSTATE, SQLE 阅读全文
posted @ 2011-10-21 17:16 catch22 阅读(4073) 评论(0) 推荐(0) 编辑