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

Card Puncher Data Processing


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.


You can avoid it by :

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

Discover More
Card Puncher Data Processing
Oracle - Recursive Calls

Sometimes, in order to execute a SQL statement issued by a user, Oracle must issue additional statements. Such statements are called : recursive calls or recursive SQL statements. For example :...

Share this page:
Follow us:
Task Runner