Affects PMD Version: 6.17
Rule:
Description: As in given example WITH clause can't be used in cursor
Code Sample demonstrating the issue:
create or replace procedure tia_uf_lr2_trf_1 is
cursor c_tariff_price(cp_obj_seq_no number) is
with obj_row as
(select orr.self_participation_variant spv
from obj_rech_r2 orr
where orr.seq_no = cp_obj_seq_no)
select 1 from dual;
begin
null;
end;
/
Running PMD through: [Designer]
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