Use FOR rec IN <variable>

[LKBrwn_DBA]

Try something like this:

...
   TYPE CurTyp IS REF CURSOR;
   rec  CurTyp;
...
BEGIN
  OPEN rec FOR v_s_sql_stmt;
  LOOP
      FETCH rec INTO {some variable(s)};
      EXIT WHEN rec%NOTFOUND;
...