存储过程中错误屏蔽

Question

begin
   str := 'select ...省略;
      execute immediate str into toll_shao_money;
      toll_shao_money := nvl(toll_shao_money,0);
exception
  when others then
     null;
end

Answer 1

.....     
      str := 'select ...省略;
      execute immediate str into toll_shao_money;
      toll_shao_money := nvl(toll_shao_money,0);
exception
    when no_data_found then 
       toll_shao_money:=0;
end;