rowtype.iterations : ROWTYPE « PL SQL Data Types « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Data Types
3. ROWTYPE

SQL>
SQL> create table job_parameters
  2  ( jobid number primary key,
  3    iterations number,
  4    table_idx number );

Table created.

SQL>
SQL>
SQL> create or replace procedure bind( p_job in number )
  2  as
  3      l_rec job_parameters%rowtype;
  4  begin
  5      select * into l_rec from job_parameters where jobid = p_job;
  6      for i in 1 .. l_rec.iterations
  7      loop
  8          execute immediate
  9          'insert into t' || l_rec.table_idx || ' values ( :x )' using i;
 10          commit;
 11      end loop;
 12      delete from job_parameters where jobid = p_job;
 13  end;
 14  /

Procedure created.

SQL> drop table job_parameters;

Table dropped.

SQL>
SQL>