ORA_01403 NO_DATA_FOUND

Oracle在存储过程中使用select f int v_f from t_name where t_id='1';

报NO_DATA_FOUND异常

------解决方法--------------------------------------------------------
select f int v_f from t_name where t_id='1'
exception
when no_data_found then
v_f  := '0';

加上异常处理机制NO_DATA_FOUND

------解决方法--------------------------------------------------------
select count(*) into v_temp from t_name where t_id='1'
if v_temp <> 0 then
select f into v_f from t_name where t_id='1'
end if;
这也是一种处理方法