PeterW
Member³
Code:
procedure proc
is
cursor c_1 (b_r1 in number
,b_r2 in varchar2)
is
select *
from table_name1
where id = b_r1;
cursor c_2 (b_r1 in number
,b_r2 in varchar2)
is
select *
from table_name2
where id = b_r1;
r_1 c_1%rowtype;
begin
open c_1 (b_r1 => 1);
fetch c_1
into r_1;
close c_1;
end proc;When you place the cursor on parameter b_r1 in the first cursor declaration, you'll see that the occurrences of b_r1 in both cursor c_1 and c_2 are highlighted. The named parameter b_r1 on line 20 (open c_1 [...]) is NOT highlighted!
Refactoring of the selected parameter also causes ALL highlighted occurences to be refactored, where I expect only changes in the selected cursor c_1, not in c_2.
Is this intended behaviour? And is it possible to also highlight/refactor the named parameters in a cursor?
