Follow the subsequend code example.
procedure m_169 (a_id number, a_261 number, a_656 number, a_171 number, a_52 number) is
begin
dbms_output.put_line ('*** m_169');
end;
begin
id := empty;
o_656 := empty;
o_171 := empty;
o_261 := empty;
o_52 := empty;
end p_seed;
/
create or replace trigger T_668_BI
before insert on o_668
begin
p_seed.id := p_seed.empty;
p_seed.o_656 := p_seed.empty;
p_seed.o_171 := p_seed.empty;
p_seed.o_261 := p_seed.empty;
p_seed.o_52 := p_seed.empty;
end;
/
create or replace trigger T_668
after insert on o_668 for each row
begin
p_seed.id (1) := :new.id;
p_seed.o_656 (1) := :new.o_656;
p_seed.o_171 (1) := :new.o_171;
p_seed.o_261 (1) := :new.o_261;
p_seed.o_52 (1) := :new.o_52;
end;
/
create or replace trigger T_668_AI
after insert on o_668
declare pragma autonomous_transaction;
begin
for i in 1 .. p_seed.id.count loop
p_seed.m_169 (p_seed.id (i), p_seed.o_261 (i), p_seed.o_656 (i), p_seed.o_171 (i), p_seed.o_52 (i));
end loop;
commit;
end;
/