i am trying to compile a simple code but getting error PLS-00306.
Can anyone help...
Here test is a table with two columns Test11 and test22
CREATE OR REPLACE PROCEDURE p1
IS
BEGIN
FOR i in (SELECT distinct test22 FROM test WHERE test1='AA')
LOOP
DBMS_OUTPUT.PUT_LINE(i);
END LOOP;
END;
Thanks