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

Card Puncher Data Processing

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





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