Home » SQL & PL/SQL » SQL & PL/SQL » Re: Need a workaround for mutating table error on trigger
Re: Need a workaround for mutating table error on trigger [message #7374] Mon, 09 June 2003 15:41
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
If the delete in T2 can only occur if the last occurance of attr1/attrb in T1 has been deleted, then you will need to defer the execution until an after statement trigger.

See here for details:

Report message to a moderator

Previous Topic: prompt box in SQL
Next Topic: Need a workaround for mutating table error on trigger
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 14:10:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.