Re: Are triggers synchronous?
From: <rwoods01_at_interserv.com>
Date: 1995/12/04
Message-ID: <49tlp6$ldg_at_data.interserv.net>#1/1
Date: 1995/12/04
Message-ID: <49tlp6$ldg_at_data.interserv.net>#1/1
Yes, triggers run synchronously and sequentially as they are part of the current transaction. The sequential order is predicated upon the current SQL statement and the database objects it impacts. Triggers that take a lot of time to execute are generally poorly designed. Triggers should always be short and sweet. In your scenario, the inserted row could only be updated from within the current transaction as it hasn't been committed yet and therefore cannot be seen by anyone else.
Rich Woods
Oracle Worldwide Customer Support
Received on Mon Dec 04 1995 - 00:00:00 CET