1

Or only row-level triggers are said to cause such mutations?

I rephrase my question:

Which trigger types will be impacted by constraining factors brought on by mutating tables?

Pop Stack
  • 926
  • 4
  • 19
  • 27
  • 4
    Why don't you try and check what happens? – Johnbabu Koppolu Mar 11 '12 at 15:29
  • 1
    +1johnbk for asking pop to try(pop without finding this by yourself you will not learn ) these guys wants you to find the answer by yourself and if you dint get the answer then'l ask ,they will definitely help you ,if you know that row level trigger gives you mutating error then what harm in removing that `for each row` clause from that trigger and them try to insert :) – Gaurav Soni Mar 11 '12 at 19:38
  • I rephrase my question: Which trigger types will be impacted by constraining factors brought on by mutating tables? – Pop Stack Mar 13 '12 at 11:56

2 Answers2

1

No.

To quote from Tom Kyte: "Only row triggers are subject to mutating table constraints, STATEMENT triggers (before/after) are not."

Jon Heller
  • 34,999
  • 6
  • 74
  • 132
0

Both can lead to mutating tables. It is a matter of what you reference in the trigger. Like the folks here have already said, try it and find out if works.

x1692
  • 24
  • 3