My Oracle Support Banner

NullPointerException or SQLException: ORA-00900: invalid SQL statement (Doc ID 293607.1)

Last updated on JANUARY 23, 2020

Applies to:

JDBC - Version 8.1.7.4 and later
Information in this document applies to any platform.

Symptoms

 

Two different errors for the same problem.

1. In Oracle JDBC9.2.0.4 or greater
   java.lang.NullPointerException
   at oracle.jdbc.ttc7.TTCAdapter.newTTCType(TTCAdapter.java:300)
   at oracle.jdbc.ttc7.TTCAdapter.createNonPlsqlTTCColumnArray(TTCAdapter.java:270)
   at oracle.jdbc.ttc7.TTCAdapter.createNonPlsqlTTCDataSet(TTCAdapter.java:231)
   at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1911)
   at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1114)
   at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2181)
   at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2063)
   at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2922)
   at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:644)
   at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:722)
   
2. In Oracle JDBC 10G

   java.sql.SQLException: ORA-00900: invalid SQL statement
   at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
   at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
   at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:180)
   at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:783)
   at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)
   at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
   at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:2979)
   at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4103)

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.