Oracle JDBC (MOSC)

MOSC Banner

Too Many Parse Errors in Oracle 19c with OJDBC6 JDBC Thin Client

edited Oct 7, 2024 3:39PM in Oracle JDBC (MOSC) 3 commentsAnswered

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center