Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    6

    Unanswered: Trigger tracing ?

    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?

  2. #2
    Join Date
    Jul 2002
    Posts
    21
    use the sequence object

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •