Dear All,
There are 3 tables, A B and C
2 after insert triggers on table A.
when there is record insert in Table A
then trigger 1 fires to insert data into B and trigger 2 fires to insert data in C.
Now C has a FK to B so before inserting into C , table B should be inserted first.
now from the above case, how we can give the priority to the two triggers so that trigger 1 fires first and then trigger 2.
as we are new to the trigger concept we are not able to find a right solution.
thanks in advance
Rgds,
shrek

You can't enforce trigger firing sequence among triggers that fire on the same event. You just can't.*

My advice:
- ONE trigger for each event.
- all executable code, or as much as possible should be in stored procedures. That way you keep control over the flow and you keep your triggers as clean as possible.