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:
JDBC - Version 11.2.0.4.0 to 21.1 [Release 11.2 to 21]Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |