Using a FUNCTION in SQL Does not Return ORA-01403 When NO_DATA_FOUND
(Doc ID 285496.1)
Last updated on APRIL 09, 2020
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)
select 2 into tmp from dual where 1=0;
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!