BEGIN
select t.subscrbid into vc_subscrbid from ucis.tab_subscrb t
where t.svcnum = lr1.mdn;
dbms_output.put_line(vc_subscrbid);
-- vc_test := vc_subscrbid;
EXCEPTION
WHEN NO_DATA_FOUND THEN
--conntinue
dbms_output.put_line('error'||vc_subscrbid);
END;
select t.subscrbid into vc_subscrbid from ucis.tab_subscrb t
where t.svcnum = lr1.mdn;
dbms_output.put_line(vc_subscrbid);
-- vc_test := vc_subscrbid;
EXCEPTION
WHEN NO_DATA_FOUND THEN
--conntinue
dbms_output.put_line('error'||vc_subscrbid);
END;
1、loop...end loop
2、while...loop
3、for...in...loop
4、goto label_name...《label_name》goto语句不能在异常处理中跳转!