My Oracle Support Banner

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:

PL/SQL - Version 9.0 and later
Information in this document applies to any platform.


ORA-01403 error not shown in SQL using a FUNCTION

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

This will return an NULL row



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.