摘要:
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 阅读全文