Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: triggers -- distinguish between bulk and individual changes
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