Bug: Invalid Hint: Variable ... is declared but never used in

[Roeland]

Consider the following code:

create or replace package pck_Test is

  type t_Test_Cursor is ref cursor return dual%rowtype;

  procedure MyMethod;

end pck_Test;

create or replace package body pck_Test is

  procedure MyMethod is
    c_Cursor t_Test_Cursor;
    r_Row    c_Cursor%rowtype;
  begin
    r_Row.Dummy := 0;
    Dbms_Output.put_line( r_row.Dummy);
  end;

end pck_Test;

When I compile this in PL/SQL dev I get

Invalid Hint: Variable 'c_Cursor' is declared but never used in 'MyMethod'

But of course I have used it! I declared the row with the cursor.

Thanks,

Roeland

 

[Marco Kalter]

Nice one. We'll fix it.

 

[T-Gergely]

Is there a workaround for this in PSD version 7.0.3.1123? Naming c_Cursor Dummy_c_Cursor doesn't help.

 

[Marco Kalter]

Have you set the "Dummy variable prefix" in the preferences to "Dummy"?

 

[T-Gergely]

It is set, but I guess it's by default.