ORA-00036: Maximum Number of Recursive SQL Levels Exceeded
ORA-00036 occurs when Oracle's internal recursive SQL call stack exceeds its maximum allowed depth, which defaults to 2000 levels. This typically happens when triggers, stored procedures, or views call each other in a circular pattern, creating an infinite loop of recursive SQL execution.
Top 3 Causes
1. Circular Trigger Dependencies
Two or more triggers fire each other indefinitely. For example, a trigger on TABLE_A updates TABLE_B, and a trigger on TABLE_B updates TABLE_A.
