firing of triggers

If i have two triggers that both fire on insert to a table, which gets fired first?

e.g CREATE OR REPLACE TRIGGER tbl_TRIGGER1 BEFORE INSERT
ON tbl
..........

CREATE OR REPLACE TRIGGER tbl_TRIGGER2
BEFORE INSERT
ON tbl
...........

Assuming that the triggers did fire in sequence, can I prevent trigger2 from firing if trigger1 contains a conditional clause that fails and which would therefore prevent the insert from taking place.

Regards
Carl Received on Fri Nov 24 2000 - 08:17:06 CST