Too Many Parse Errors in Oracle 19c with OJDBC6 JDBC Thin Client
We are experiencing frequent "too many parse errors" warnings in our Oracle 19c database when executing queries via JDBC Thin Client using ojdbc6.jar
. The issue arises with specific SQL statements targeting tables such as UNIFIERIDINTEGERJOB
and JOBRUNTABLE
. Sample errors are as follows:
PARSE ERROR: ospid=19095, error=936:
SQL: select rowid as "Oracle_JDBC_interal_ROWID", * FROM UNIFIERIDINTEGERJOB WHERE JOBNAME='IDINTEGERUTIL'
PARSE ERROR: ospid=19097, error=936:
SQL: select rowid as "Oracle_JDBC_interal_ROWID", * FROM JOBRUNTABLE WHERE JOBNAME='LEGALENTITYUTIL'
The error count exceeds 100 for both SQL hashes (0x3f889631 and 0xcf622941). We are using ojdbc6.jar
with Oracle 19c, and the error code 936 suggests an issue during SQL parsing.