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 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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) |