Unix Technical Forum

create trigger and DML

This is a discussion on create trigger and DML within the Oracle Database forums, part of the Database Server Software category; --> What happen when during the 'create trigger ...' on a table, a DML takes place on the table? Does ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-25-2008, 02:51 AM
Daud
 
Posts: n/a
Default create trigger and DML

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-25-2008, 02:53 AM
DA Morgan
 
Posts: n/a
Default Re: create trigger and DML

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@x.washington.edu
(replace x with u to respond)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 03:59 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com