Execute procedure in a trigger

sql oracle stored-procedures execute

user207902 · Nov 10, 2009 · Viewed 45.4k times · Source

Is it possible to execute a stored procedure inside a trigger?

Thank you

Answer

Yes, like this:

create or replace trigger trg
after insert on emp
for each row
begin
   myproc(:new.empno, :new.ename);
end;