I am missing some code, but it seems that:
for dept_rec in deptCk Loop
open generic_cursor for select * from Dept
where deptd = dept_rec.deptId;
end loop;
loops complete through dept_rec and then exits the procedure
and that is at the last record.
|
Results 1 to 2 of 2
Thread: Cursor For Loop QuestionThreaded View
|
Click Here to Expand Forum to Full Width |