Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: triggers -- distinguish between bulk and individual changes

Re: triggers -- distinguish between bulk and individual changes

From: Phil Haigh <phil.haigh_at_fwpharma.com>
Date: Tue, 22 May 2001 22:36:48 +0100
Message-ID: <SZAO6.1650$8Z5.76555@monolith.news.easynet.net>

dportnoy wrote in message
<3458aca6.0105211333.14a56b15_at_posting.google.com>...
>I am trying to create audit routines in which bulk data changes to the
>entire table are logged only once, while logging each manual change to
>individual records. So I think I need to figure out any of the
>following:
>
> * From within a row-level trigger, is there any way to identify
>whether other rows are being affected by the same SQL statement?

There's no way to do this.

>
> * From within a statement-level trigger, is there any way to determe
>how many rows are being affected?

No.

>
> * From within a statement-level trigger, is there any way to determe
>the SQL statement being run?

No.

>
>Thanks.

Sorry but what you want to do is not feasible. Not in triggers, anyway.

Phil Haigh
Oracle Certified Professional - Developer 6i Received on Tue May 22 2001 - 16:36:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US