ORA-01000 and ORA-00942 When Using JDBC 12.1 Drivers on SQL statements Related to ParameterMetaData
(Doc ID 1997925.1)
Last updated on AUGUST 09, 2023
Applies to:
JDBC - Version 12.1.0.1.0 to 12.1.0.2.0 [Release 12.1]Information in this document applies to any platform.
Symptoms
JDBC application using JDBC/thin 12.1.0.2 ( ojdbc7.jar) fails with either :
ORA-1000: maximum open cursors exceeded
or
ORA-942: table or view does not exist
while calling ParameterMetaData getParameterMetaData().
The SQL statements involved with the cursor issue and missing table are generated by the JDBC driver metadata not the application code.
The issue does not reproduce in JDBC 11.2.0.4 (ojdbc6.jar).
Changes
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 |