PeterW
Member³
Use the following code:
When you select the cursor variable b_var1 (line 3), you'll see that the occurences of b_var1 in both cursor c1 and c2 are highlighted. When you refactor b_var1 (of cursor c1), ALL occurences in the declaration part (lines 3-16) are refactored, including those of cursor c2. The occurences between BEGIN..END are NOT highlighted nor refactored.
Is this desired behaviour?
Version: 8.0.4.1514
Code:
create or replace procedure test
is
cursor c1 (b_var1 in number)
is
select 1
from dual
where dual.dummy = b_var1;
cursor c2 (b_var1 in varchar2)
is
select 1
from dual
where dual.dummy = b_var1;
l_varn number;
l_varc varchar2(1);
BEGIN
open c1 (b_var1 => 1);
fetch c1
into l_varn;
close c1;
open c2 (b_var1 => 1);
fetch c2
into l_varc;
close c2;
END test;
When you select the cursor variable b_var1 (line 3), you'll see that the occurences of b_var1 in both cursor c1 and c2 are highlighted. When you refactor b_var1 (of cursor c1), ALL occurences in the declaration part (lines 3-16) are refactored, including those of cursor c2. The occurences between BEGIN..END are NOT highlighted nor refactored.
Is this desired behaviour?
Version: 8.0.4.1514