Skip to Main Content

SQL & PL/SQL

using :old and :new as parameters

herzalAug 13 2009 — edited Aug 13 2009
Hi 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 =)
This post has been answered by 21205 on Aug 13 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2009
Added on Aug 13 2009
8 comments
569 views