org.sonar.l10n.plsqlopen.rules.plsql.TooManyRowsHandler.html Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of zpa-checks Show documentation

Z PL/SQL Analyzer :: Checks

The newest version!


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;