ORA-01000 and ORA-00942 When Using JDBC 12.1 Drivers on SQL statements Related to ParameterMetaData
Last updated on JUNE 01, 2018
Applies to:JDBC - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 12.1]
Information in this document applies to any platform.
JDBC application using JDBC/thin 188.8.131.52 ( ojdbc7.jar) fails with either :
ORA-1000: maximum open cursors exceeded
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 184.108.40.206 (ojdbc6.jar).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms