Re: Are triggers synchronous?

Triggers are synchronous. The row is locked while the first transaction is in progress, so the second transaction - the update - will have to wait for the first to complete before it can perform the update.

Almut Herzog (al-her_at_sectra.se) wrote:
: Hi,
 

: imagine this scenario: A trigger is started on insertion of a row. That
: trigger takes "a lot of time" to execute its code. During that execution,
: the inserted row is updated, which causes the same trigger to execute
: again.
 

: Is the row locked while the trigger executes? Do triggers execute
: synchronously/sequentially? What happens?
 

: E-mail replies appreciated!
: /Oracle-Newbie
 

: --
: Almut Herzog email:al-her_at_sectra.se
: SECTRA - Secure Transmission AB fax: ++46 13 212185
: Linkoping, Sweden
Received on Tue Dec 05 1995 - 00:00:00 CET