Use explicit cursor to fetch and store value to number variable
SQL> create table myTable(
2 x number,
3 y char(100)
4 );
Table created.
SQL>
SQL> insert into myTable
2 select rownum, 'padding'
3 from all_objects
4 where rownum < 10001;
10000 rows created.
SQL>
SQL>
SQL>
SQL> create or replace procedure explicit is
2 cursor explicit_cur is
3 select 1
4 from myTable
5 where x = 1;
6 dummy number;
7 begin
8 for i in 1 .. 500 loop
9 open explicit_cur;
10 fetch explicit_cur
11 into dummy;
12 close explicit_cur;
13 end loop;
14 end;
15 /
Procedure created.
SQL>
SQL> drop table myTable;
Table dropped.
Related examples in the same category