Search code examples
sqloracle-databaserecursionlimit

Is there any way to increase recursion levels limit in Oracle?

It is well known that being careless when writing SQL triggers can lead to a following problem:

ORA-00036: maximum number of recursive SQL levels (50) exceeded

When I look for this problem solutions, all of them are simple: fix your code because it has issues. And in all cases it turns out to be a good advice.

But for the academic purposes: is there any way to increase this maximum number? I see that sometimes it is refered as:

maximum number of recursive SQL levels (string) exceeded

So maybe there is a way to put your own value under this string?

Solution

  • Hmm, depends. The documentation says

    Trigger Cascade Limit: Operating system-dependent, typically 32