Q: Order of triggers firing.

Greetings from an Oracle newbie.
Here is my question:
Assume two tables: TableA, TableB.
Also, assume the following triggers:

Trig1: Statement-level trigger before delete on TableA
Trig2: Row-level trigger after delete on TableA
Trig3: Statement-level trigger after delete on TableA
Trig4: Statement-level trigger before delete on TableB
Trig5: Row-level trigger after delete on TableB
Trig6: Statement-level trigger after delete on TableB

Finally, assume Trig2 issues a delete statement on one or more records in TableB

The behaviour I would like to see is :
Triggers fired in the following chronological order:

Trig1
Repeat for each row deleted in Table A

	Trig2
	Trig4
	Repeat for each record deleted in TableB by statement in Trig2
		Trig5
	end repeat
	Trig3

Question: Can this chronological order be confirmed and guaranteed?

Thanks in advance for the answer!

Mick Received on Tue Oct 14 1997 - 00:00:00 CEST