Hi to all,

Here is my problem. I have two tables - T1 and T2, T2 referencing T1 with On Delete Cascade. I have a before delete trigger on T1 and after delete trigger on T2. I need do some operations in the trigger on T2, but only if the initial command was delete from T2, not from T1. So I need a way to determine in the trigger on T2 if the trigger on T1 has already fired. Is there any way I can do this?

use the sequence object