how do i loop through a cursor using fetch statement

[2314]

how do i loop through a cursor using fetch statement

 

[lewisp]

OPEN my_cursor(params?);
LOOP
  FETCH my_cursor INTO my_vars;
--
  EXIT WHEN my_cursor%NOTFOUND;
END LOOP;

or, better is without FETCH:

FOR c IN my_cursor(params?)
LOOP
  do_something;
END LOOP;