Re: Doubt regarding sequence of trigger execution
- From: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Sep 2014 15:00:37 -0300
Hi,
I got the solution. In 11g we can use the FOLLOWS
SQL> create or replace trigger trg_test_02
2 before insert on t1
3 for each row
4 follows trg_test_01
5 begin
6 dbms_output.put_line('trigger trg_test_02');
7 end;
8 /
2014-09-25 14:39 GMT-03:00 Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>:
> 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:
