Autonomous_transaction

[shanshanrefer]

Dear Sir,

I wrote 3 procedures in a package and all are autonomous_transaction. I want to fill a table named t1 based on these three procedures. But while executing the 3 procedures are not filling the data at a time. Please advice me.

PACKAGE BODY EXEC is
procedure pro1 is
pragma autonomous_transaction;
begin
for i in 1..100000 loop
insert into t1 values(i,'a');
commit;
end loop;
end;
procedure pro2 is
pragma autonomous_transaction;
begin
for i in 1..100000 loop
insert into t1 values(i,'b');
commit;
end loop;
end;
procedure pro3 is
pragma autonomous_transaction;
begin
for i in 1..100000 loop
insert into t1 values(i,'c');
commit;
end loop;
end;
END;

call method
execute exec.pr01;
execute exec.pr02;
execute exec.pr03;

Regards,
Shan"

[debasisdas]

Can you please specify what do you mean by filling the data at a time.

What exactly u want to achieve.

I think data must be inserting to the table by executing the procedure.