oracle exception no data found code example
Example 1: no data found oracle
BEGIN
select... into...
EXCEPTION WHEN NO_DATA_FOUND THEN
do_something
END;
Example 2: oracle no data found error code
NO_DATA_FOUND : ORA-01403
BEGIN
select... into...
EXCEPTION WHEN NO_DATA_FOUND THEN
do_something
END;
NO_DATA_FOUND : ORA-01403