using :old and :new as parameters
herzalAug 13 2009 — edited Aug 13 2009Hi all,
is it possible that a trigger can call a procedure and use :old and :new as parameters? Kinda like this
create or replace trigger logTrigger after update on test_table for each row
begin
logProcedure(:old, :new)
end;
create or replace procedure logProcedure (oldRow in test_table%rowtype,newRow in test_table%rowtype) is
begin
-- do some stuff
end;
thanks for your help =)