Insert From JDBC Fails With ORA-00036 After Database OCT 2020 PSU Is Applied (Doc ID 2757609.1)

Last updated on JUNE 05, 2023

Applies to:

Symptoms

An application using JDBC 11.2.0.3 or higher and performing an insert on a table with an index in database 12.1.0.2 fails with the exception:

java.sql.SQLException: ORA-00036: maximum number of recursive SQL levels () exceeded
      at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
      at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
      at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)
      at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37)
      at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)
      at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1276)
      at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:366)
     
Caused by: Error : 36, Position : 12, Sql = insert into ...., OriginalSql = insert into ..., Error Msg = ORA-00036: maximum number of recursive SQL levels () exceeded
      at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
      ... 12 more


The same insert does not reproduce the error with SQL*Plus.
The insert is successful if the index is not created.
The issue occurs only after the Oct 2020 PSU patch is applied to the database.

Changes

 Patch:31511219 (Oct 2020 PSU) was applied to the database.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.