Skip to main content

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;