Pular para o conteúdo principal

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;