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;
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;