java.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got CLOB

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via schemacrawler by *anonymous
, 1 year ago
ORA-00932: inconsistent datatypes: expected - got CLOB
via schemacrawler by dayglo2
, 1 year ago
ORA-00932: inconsistent datatypes: expected - got CLOB
via Oracle Community by 558820, 1 year ago
ORA-00942: table or view does not exist
via Stack Overflow by javaExpert
, 2 years ago
ORA-00942: table or view does not exist
via i2b2.org by Unknown author, 1 year ago
ORA-00904: "START_DATE": invalid identifier
via i2b2.org by Unknown author, 1 year ago
java.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got CLOB
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:801)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:841)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1696)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1662)
at schemacrawler.tools.operation.OperationFormatter.handle(OperationFormatter.java:248)
at schemacrawler.crawl.DatabaseSchemaCrawler.crawlTables(DatabaseSchemaCrawler.java:401)
at schemacrawler.crawl.DatabaseSchemaCrawler.crawl(DatabaseSchemaCrawler.java:161)
at schemacrawler.tools.operation.OperationExecutable.execute(OperationExecutable.java:87)
at schemacrawler.main.SchemaCrawlerMain.schemacrawler(SchemaCrawlerMain.java:63)
at schemacrawler.Main.main(Main.java:47)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 7 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.