Oracle自带的exception
时间:2021-07-01 10:21:17
帮助过:8人阅读
查询人员资料历史
BEGIN
SELECT *
INTO Po_Sac01
FROM Sac01
WHERE Aac001
= Pi_Aac001
AND Pi_Jfny
BETWEEN Aae041
AND Nvl(Aae042,
999999);
EXCEPTION
WHEN No_Data_Found
THEN
Po_Fhz := v_Procname
|| ‘_001‘;
Po_Msg := ‘未找到人员资料历史记录‘ || v_Params;
RETURN;
WHEN Too_Many_Rows
THEN
Po_Fhz := v_Procname
|| ‘_002‘;
Po_Msg := ‘找到多条人员资料历史记录‘ || v_Params;
RETURN;
END;
Oracle自带的exception
标签: