Toad World® Forums

Code Analysis: Rule 6407 does not check if variable is used by queries

DECLARE
v_num PLS_INTEGER; – Ensure item is defined in as deep a scope as possible.
BEGIN
SELECT COUNT(1) INTO v_num FROM dual;
SELECT 1 INTO v_num FROM dual WHERE v_num = 1;

BEGIN
v_num := 1;
END;
END;

I’ll link this one to http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/27585/59324#59324 .