Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Mutating Trigger??
Thomas Kyte wrote:
| create or replace trigger emp_bd
| before delete on emp
| begin
| emp_pkg.empnos := emp_pkg.empty;
| end;
| /
|
| create or replace trigger emp_adfer
| after delete on emp for each row
| begin
| emp_pkg.empnos( emp_pkg.empnos.count+1 ) := :old.mgr;
| emp_pkg.enames( emp_pkg.empnos.count ) := :old.ename;
| end;
| /
What if two or more transactions are started that delete rows from the emp table. And that these transactions are started very close to the same time. Would not trigger emp_bd be executed once for each delete. And couldn't/wouldn't this interfere with the emp_adfer trigger's logic?
later,
Ed
Received on Thu Dec 03 1998 - 14:56:39 CST