Below is the pl sql code i am trying to execute but i am getting an error.
create or replace
PROCEDURE PROCEDURE2 IS
cursor c_student is select * from PS_SCRTY_TBL_STGP;
fetch c_student into r_student;
for inst in (select INSTITUTION from PS_SCRTY_TBL_INST where OPRID=r_student.OPRID)
/*if eachInstitution !=r_student.INSTITUTION THEN*/
/*delete from PS_SCRTY_TBL_STGP where OPRID=r_student.OPRID and INSTITUTION=inst;*/
end loop ;
Error(16,5): PLS-00306: wrong number or types of arguments in call to 'PUT_LINE'
1) Why am i getting this error?
2) lso i would like to know whether my approach of looping through the record is correct?