Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: create trigger and DML

Re: create trigger and DML

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 26 Jan 2006 13:13:09 -0800
Message-ID: <1138309986.186591@jetspin.drizzle.com>


Daud wrote:
> 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_at_x.washington.edu
(replace x with u to respond)
Received on Thu Jan 26 2006 - 15:13:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US