Oracle Error ORA-23350: maximum number of recursive calls exceeded

Oracle Error Message

ORA-23350: maximum number of recursive calls exceeded

Reason for the Error

This usually occurs when trying to resolve conflicts in a table while concurrent updates to the same row create more conflicts.

Solution

Re-execute the deferred transaction from DefError using dbms_defer_sys.execute_error