Oracle Error ORA-06597: Failed to increase the session’s call stack memory to string bytes at a depth of string calls. (The current maximum is string bytes.)

Oracle Error Message

ORA-06597: Failed to increase the session’s call stack memory to string bytes at a depth of string calls. (The current maximum is string bytes.)

Reason for the Error

PL/SQL program execution used more call stack memory than permitted.

Solution

* Ask your DBA to increase the maximum allowed call stack memory.

* Decrease the amount of call stack used by the program. This may be accomplished by using fewer, smaller local variables, or by limiting the depth of function call nesting.