-
I'm receiving the infamous mutating table error when a trigger is fired. I have seen the various workarounds and I don't think they apply for my scenario. Basically, the problem is that the trigger fires another trigger - Here's the pseudo-code.
before update of user.email on table user
update team
set team.email = user.email where user.id = team.id
So, that was no big deal to set. It was working fine. Here's the problem. I've set up a trigger on team that needs to query user, thus, the dreaded mutating table error.
before update of team
where team.email = emp.email
set team.id = user.id
From the applications point of view these triggers should be fired b/c of separate actions. From the database point of view, the second trigger gets fired b/c the first one calls an update of team.
Any suggestions for a workaround? Thanks for the help.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|