Michael Kreitmann wrote:
> If I define the trigger "FOR EACH ROW", the trigger will be fired n-times
> if the firing statement will hit n records. Is there any unique ID or hash-code
> or anything else, that is equal for all of these n executions of this trigger
> (and only for these n executions ? - the next statement firing the trigger
> must produce a new (unique) ID ...)
There's probably something you could put together from state information
that would be unique. However, you could just create a sequence and
call MY_SEQ.NEXTVAL in a statement level trigger. Then use
MY_SEQ.CURRVAL in the FOR EACH ROW trigger.
--
Richard Kuhler
Received on Thu Nov 11 2004 - 12:48:03 CST
