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

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.

Solution

You can avoid it by :

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

Powered by ComboStrap