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

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

Data Science
Data Analysis
Data Science
Linear Algebra Mathematics

Powered by ComboStrap