create or replace procedure open_cursor(
p_cursor1 in out types.rc, p_cursor2 in out types.rc )
2 as
3 pragma autonomous_transaction; --- look this
4 begin
5 set transaction read only; --- look this
6
7 open p_cursor1 for select ename from emp;
8
9 dbms_lock.sleep( 60 ); -- in another session delete from emp and commit
10
11 open p_cursor2 for select ename from emp;
12 commit;
13 end;
14 /