Request: hints, unused variables

[Claus Pedersen]

I have a request: is it possible to have a hint if a variable that is implicit declared is also explicitly declared but not used?

Example:

PROCEDURE tester IS
  cur_emp emp%ROWTYPE;
BEGIN
  FOR cur_emp IN (SELECT * FROM emp) LOOP
    cur_emp.sal := cur_emp.sal * 1.05;
  END LOOP;
END;

Here, the declaration of cur_emp can be omitted, it is possible to have a hint:
Variable 'cur_emp' is declared but never used ...
or similar?

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[William Robertson]

Good point, it IS declared but never used. I see that quite a lot (with numeric loops as well) so this would be a useful check.

 

[Worker]

On the same topic, I would like to request hints for unused values that were assigned through OUT parameters.

Example:

procedure foo is
	version		varchar2(32767);
	compatibility	varchar2(32767);
begin
	dbms_utility.db_version( version, compatibility );
end;

 

[Claus Pedersen]

Any news on this topic?