Oracle - Recursive calls caused by data modification (triggers, function based index, ...)

> Database > Oracle Database

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.

3 - Solution

You can avoid it by :

  • avoiding as much recursive SQL as possible
  • moving SQL out of the trigger into a package