Question

oracle 过程里怎么捕获方法里抛出的异常

oracle 过程里怎么捕获方法里抛出的异常
begin
select to_number(public_f_get_aaa032(v_aab003,trunc(sysdate),'023','03')) into v_bccl04_xm from dual;
exception when others then
retcode := 1;
rettext := 'alert("请设置创业项目补贴标准参数！");v = false;';
return;
end ;
过程里捕获public_f_get_aaa032的异常，现在public_f_get_aaa032异常，select to_number(public_f_get_aaa032(v_aab003,trunc(sysdate),'023','03')) into v_bccl04_xm from dual; 正常执行 v_bccl04_xm 为null

Answer 1

EXCEPTION
WHEN excepttion_name1 then
........
WHEN excepttion_name2 then
........
WHEN excepttion_name3 then
........
End;

追问

哪有这么简单啊