Using a FUNCTION in SQL Does not Return ORA-01403 When NO_DATA_FOUND (Doc ID 285496.1)

Last updated on FEBRUARY 17, 2022

Applies to:

Symptoms

ORA-01403 error not shown in SQL using a FUNCTION


create table t(x number);
----
create or replace function ora1403(x number)
return number
is
tmp number;
begin
select 2 into tmp from dual where 1=0;
return tmp*x;
end;
/
select ora1403(x) from t;

This will return an NULL row

Cause