create trigger and DML

#1

What happen when during the 'create trigger ...' on a table, a DML
takes place on the table? Does the DML fail or does it wait for the
'create trigger' to complete before running?

Thanks

Daud

#2

Daud wrote:

Quote:

What happen when during the 'create trigger ...' on a table, a DML
takes place on the table? Does the DML fail or does it wait for the
'create trigger' to complete before running?

Thanks

Daud

If there is DML taking place while you are creating a trigger you
need to go back to Software 101 and learn about change management
concepts.

STARTUP RESTRICT may just be a good idea but it should be the law.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

create trigger and DML

comp.databases.oracle.server comp.databases.oracle.server

create trigger and DML - 01-25-2006 , 10:40 PM

Re: create trigger and DML - 01-26-2006 , 03:13 PM