Hi,

I create a cursor like this:

SQL> CREATE OR REPLACE PROCEDURE Update_STUD_FinAid ( AIDY_CODE IN VARCHAR2 ) IS
  2    CURSOR PublicationC IS
  3      SELECT SGBSTDN_USER_ID from SGBSTDN
  4       WHERE SGBSTDN_TERM_CODE_EFF ='201030';
  5  BEGIN
  6    close PublicationC;
  7    
  8    OPEN PublicationC;
  9  
 10    FOR PublicationR IN PublicationC
 11    LOOP
 12      DBMS_OUTPUT.PUT_LINE( PublicationR.SGBSTDN_USER_ID );
 13    END LOOP;
 14  
 15    close PublicationC;
 16   
 17  END;
 18  /

Procedure created.

And then when I run the Procedure then I get this error:

ERROR at line 1:
ORA-06512: at line 2

Please advise.

Thanks