-- 異常處理 begin 後 聲明變量的時候加上下面的
declare _err int default 0;
declare continue handler for sqlexception, sqlwarning, not found set _err=1;
-- 代碼結尾 加上
if _err=1 then
rollback;
select '-10000' as rscode, 'XXXX異常!' as rsmsg from dual;
leave label;
end if;