Toad World® Forums

13.3: Find Unused Identifiers - false positives

False positives by Refactor -> Find Unused Identifiers:

DECLARE
  tst tst_ot := NEW tst_ot();
BEGIN
  tst.some_method();
END;

DECLARE
  v_tab dbms_sql.Number_Table;
BEGIN
  v_tab(1) := 1;
END;

DECLARE
  v_dual dual%ROWTYPE;
BEGIN
  v_dual.dummy := 1;
END;

CREATE PACKAGE BODY pac
AS
  CURSOR cur( in_dummy IN dual.dummy%TYPE ) IS
    SELECT * FROM dual WHERE dummy = in_dummy;
END pac;

CREATE OR REPLACE PACKAGE BODY pac AS
  PROCEDURE forward_declared( in_x IN PLS_INTEGER );

  PROCEDURE forward_declared( in_x IN PLS_INTEGER )
  AS
  BEGIN
    dbms_output.put_line( in_x );
  END forward_declared;
END pac;