Are triggers synchronous?

From: Almut Herzog <al-her_at_sectra.se>
Date: 1995/11/30
Message-ID: <al-her-3011951345190001_at_192.36.244.79>#1/1


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 Thu Nov 30 1995 - 00:00:00 CET

Original text of this message