Doubt regarding sequence of trigger execution
- From: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Sep 2014 14:39:50 -0300
Hi all,
I have a table with 2 triggers.
I would like to know if exists a way to control the sequence of execution
of its.
I cannot use only one trigger. I need of 2 triggers. It is too complex for
business rules change it (at this moment).
The trigger 1 is like this:
AFTER INSERT or UPDATE or DELETE ON CTAB
FOR EACH ROW
The trigger 2 is like is:
AFTER INSERT OR UPDATE ON CTAB
FOR EACH ROW
I need trigger running first of trigger 2.
How can I force execute trigger1 and trigger2 in the sequence ?
Regards
Eriovaldo
Other related posts:
