Oracle - Recursive calls caused by data modification (triggers, function based index, ...)
Table of Contents
1 - About
When you are doing data modification, you can fired many side effects as :
- …
which include also other SQL statement and improve then the recursive calls metrics.
2 - Articles Related
3 - Solution
You can avoid it by :
- avoiding as much recursive SQL as possible
- moving SQL out of the trigger into a package
Advertising