SQL>
SQL>
SQL> create table t ( x int );
Table created.
SQL> create or replace procedure proc1
2 as
3 begin
4 for i in 1 .. 10000
5 loop
6 execute immediate 'insert into t values ( :x )' using i;
7 end loop;
8 end;
9 /
Procedure created.
SQL> create or replace procedure proc2
2 as
3 begin
4 for i in 1 .. 10000
5 loop
6 execute immediate 'insert into t values ( '||i||')';
7 end loop;
8 end;
9 /
Procedure created.
SQL> exec proc1
PL/SQL procedure successfully completed.
SQL> exec proc2
PL/SQL procedure successfully completed.
SQL>
SQL> drop table t;
Table dropped.