SQL> create table myTable ( x primary key ) organization index as select 1 from dual;
Table created.
SQL>
SQL> create or replace procedure explicit2 is
2 cursor explicit_cur is select 1 from myTable;
3 dummy number;
4 begin
5 open explicit_cur;
6 for i in 1 .. 50000 loop
7 fetch explicit_cur into dummy;
8 end loop;
9 close explicit_cur;
10 end;
11 /
Procedure created.
SQL>
SQL> drop table myTable;
Table dropped.
|