Affects PMD Version: 6.17.0
Rule:
Description: ParseException with cursor declared inside procedure declared inside anonymous block declare section
Code Sample demonstrating the issue:
declare
gw_start_date date := to_date('2017-01-01', 'yyyy-mm-dd');
gw_acl_name varchar2(100);
procedure create_acl(p_acl_name in varchar2) is
cursor c_acl is
select dna.acl
from dba_network_acls dna
where acl like '%' || p_acl_name;
w_acl_name varchar2(100);
begin
open c_acl;
fetch c_acl
into w_acl_name;
close c_acl;
end;
begin
null;
end;
/
Running PMD through: [CLI]
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