Re: After statement level trigger iring before after row level trigger
From: Bobby Z. <vladimir.zakharychev_at_gmail.com>
Date: Thu, 19 Mar 2009 23:25:01 -0700 (PDT)
Message-ID: <f1b60585-c110-4360-8842-394f4c319715_at_j38g2000yqa.googlegroups.com>
On Mar 19, 12:17 pm, PeteDaMeat <peterlaz..._at_gmail.com> wrote:
> I have a database table which has an after statement level trigger
> firing before the after row level trigger, does anyone have any
> suggestions as to what could be causing this?
Date: Thu, 19 Mar 2009 23:25:01 -0700 (PDT)
Message-ID: <f1b60585-c110-4360-8842-394f4c319715_at_j38g2000yqa.googlegroups.com>
On Mar 19, 12:17 pm, PeteDaMeat <peterlaz..._at_gmail.com> wrote:
> I have a database table which has an after statement level trigger
> firing before the after row level trigger, does anyone have any
> suggestions as to what could be causing this?
Oracle version (up to fifth digit?) Is this behavior reproducible? Can you demonstrate it with a test case (just instrument every trigger with a call to dbms_output.put_line('TRIGGER_NAME (BEFORE STMT|BEFORE ROW|AFTER ROW|AFTER STMT) fired.', do some DML against the affected table and show us the log.)
Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
Received on Fri Mar 20 2009 - 01:25:01 CDT