Bug?: refactoring cursor variables

PeterW

Member³
Use the following code:

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
 
Back
Top