Re: triggers

From: Steve Howard <stevedhoward_at_gmail.com>
Date: 16 Nov 2006 09:47:07 -0800
Message-ID: <1163699227.277507.154400@b28g2000cwb.googlegroups.com>

schw wrote:
> hi all,
>
> can one trigger be fired twice simultaneously ? I've got one trigger
> that writes to a file and I'm worried that if the triggers is fired
> twice simultaneously I end up with garbage in the file.
>
> what do you think?
>
> regards,
> schw

In a given session for a given operation it only fires once. If the table on which the trigger is based is heavily updated/deleted/inserted, or whatever event for which the trigger fires, it sounds from your description like you could have multiple sessions writing to your file at the same time. You can use DBMS_LOCK if you are writing to an external file and need to serialize access to it.

HTH, Steve Received on Thu Nov 16 2006 - 11:47:07 CST