Run the procedure in the trigger

Question

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

thanks

Answer 1

Yes, like this:

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

Answer 2

Yes, you can start the procedure from a trigger. But keep in mind that trigger and procedure e should not have the same table.

Answer 3

In SQL Server, this is so. What DBMS do you use?

ETA: Oracle, huh? I have no personal experience, but that seems to indicate that you can. I found this by googling the "stored Oracle launch procedure".

Answer 4

Yes, you can. Just keep in mind that a trigger can fire for every line affected by a DML trigger. Therefore, your stored procedure must be optimized or you may run into performance issues. Triggers are good, but you just need to keep in mind the performance issues that you might encounter when using them.