SQL & PL/SQL

Why is the procedure showing up as invalid when it worked successfully?

Could it be an old procedure that is still there even though the latest one worked successfully?

If so, how can you get rid of it so when I check the object status it does not show up as an invalid procedure?

Thanks again guys

................

set serveroutput on

DECLARE
CURSOR c1 IS SELECT first_name from customer;
v_string varchar2(30);
v_number number;

PROCEDURE proc is
BEGIN
DBMS_OUTPUT.PUT_LINE('Proc');
END proc1;

PROCEDURE proc2 is
BEGIN
DBMS_OUTPUT.PUT_LINE('Proc2');
OPEN c1;
LOOP FETCH c1 INTO v_string;
EXIT WHEN c1%NOTFOUND;
DBMS_OUTPUT.PUT_LINE('v_string: '||v_string);
END LOOP;
CLOSE c1;
END proc2;