explicit cursor with cursor variable : Explicit Cursor « Cursor « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Cursor
3. Explicit Cursor

SQL>
SQL> create table myTable (x primary key) organization index as select 1 from dual;

Table created.

SQL>
SQL>
SQL>
SQL>
SQL> create or replace procedure explicit is
  2    cursor explicit_cur is select 1 from myTable;
  3    dummy number;
  4  begin
  5    for i in 1 .. 500 loop
  6       open explicit_cur;
  7       fetch explicit_cur
  8       into dummy;
  9       close explicit_cur;
 10    end loop;
 11  end;
 12  /

Procedure created.

SQL>
SQL>
SQL> drop table myTable;

Table dropped.