ORA-00036 Error -> Maximum Number of Recursive SQL Levels (%s) Exceeded

By Santhosh N

This explains the oracle error, ORA-00036 in detail, the possible reason(s) and steps to solve the same in Oracle Database.

Oracle Error: ORA-00036

Description: Maximum Number of Recursive SQL Levels (%s) Exceeded.

Reason(s) for this Oracle error: This error will be raised when an attempt was made to go beyond the specified number of recursive SQL levels.

Possible steps to solve this error:
1) Try to remove the recursive SQL statement which is causing this error, possibly could be because of recursive trigger.

Related FAQs

ORA-00035 Error -> LICENSE_MAX_USERS cannot be less than current number of Users
This explains the oracle error, ORA-00035 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
ORA-00034 Error -> Cannot COMMIT or ROLLBACK in Current PL/SQL Session
This explains the oracle error, ORA-00034 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
ORA-00033 Error -> Current Session has Empty Migration Password
This explains the oracle error, ORA-00033 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
ORA-00032 Error -> Invalid Session Migration Password
This explains the oracle error, ORA-00032 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
ORA-00031 Error -> Session marked for kill
This explains the oracle error, ORA-00031 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
ORA-00030 Error -> User Session ID does not exist
This explains the oracle error, ORA-00030 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
ORA-00036 Error -> Maximum Number of Recursive SQL Levels (%s) Exceeded  (1571 Views)