Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
moonia.das
Starting Member
2 Posts |
 Posted - 2010-02-22 : 02:22:27
|
| Hi AllI am unable to understand why row level triggers cant be used in mutating tables.Can anyone explain me?Also I came across the following para while looking for the answer which also I am unable to understand :If you need to update a mutating table, you could bypass these restrictions by using a temporary table, a PL/SQL table, or a package variable. For example, in place of a single AFTER row trigger that updates the original table, resulting in a mutating table error, you might use two triggers—an AFTER row trigger that updates a temporary table, and an AFTER statement trigger that updates the original table with the values from the temporary table.If you giv an eg it would be betterThanks |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-02-22 : 02:41:32
|
try posting your question over at a oracle forum. SQLTeam is for Microsoft SQL Server
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
Mutating tables in row level trigger