create or replace procedure impl_cursor as
     v_row dba_source%ROWTYPE;
begin
     select * into v_row from dba_source where line=9999;
     dbms_output.put_line(v_row.text);
end;
/

create or replace procedure expl_cursor as
       v_row dba_source%ROWTYPE;
       cursor test_cur is select * from dba_source where line=9999;
begin
     open test_cur;
     fetch test_cur into v_row;
     close test_cur;
     dbms_output.put_line(v_row.text);
end;
/

exec runStats_pkg.rs_start;
exec expl_cursor;
exec runStats_pkg.rs_middle;
exec impl_cursor;
exec runStats_pkg.rs_stop;