A RetroSearch Logo

Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Search Query:

Showing content from https://github.com/pmd/pmd/issues/1733 below:

[plsql] % not supported in "TestSearch%notfound" · Issue #1733 · pmd/pmd · GitHub

Affects PMD Version:
pmd-bin-6.12.0
Rule:
TomKytesDespair
Description:
Parse Exception:

Caused by: net.sourceforge.pmd.lang.plsql.ast.ParseException: Encountered " "%" "% "" at line 23, column 18.

Code Sample demonstrating the issue:

CREATE OR REPLACE PACKAGE lpe_test is

procedure testif;

end lpe_test;
/

CREATE OR REPLACE PACKAGE BODY lpe_test is


procedure testif
is
cursor TestSearch
is
select 1 from dual;

TestRow TestSearch%rowtype;

begin
    open TestSearch;
    fetch TestSearch into TestRow;

    if TestSearch%notfound then
        DBMS_OUTPUT.PUT_LINE('Not found');
    else
        DBMS_OUTPUT.PUT_LINE('Found');
    end if;
    close TestSearch;
end testif;

end lpe_test;
/

Running PMD through: [ Ant or standalone with JDK 1.8]
pmd-bin-6.12.0/bin/run.sh pmd -d /home/tstdba/dcs/jenkins/test_plsql_pmd_issue.sql -l plsql -R rulesets/plsql/TomKytesDespair.xml -f xml


RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4