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 APRIL 09, 2020

Applies to:

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

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

 

Changes

 

Cause

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.