Avoid masking the TOO_MANY_ROWS exception
When a SELECT INTO statement causes the predefined exception TOO_MANY_ROWS the values of the variables in the INTO clause are undefined.
Noncompliant Code Example
begin
select empno
into var
from emp;
exception
when too_many_rows then
null;
end;
Compliant Solution
begin
select empno
into var
from emp;
exception
when too_many_rows then
var := null;
end;