java.sql.SQLException

ORA-01790: expression must have same datatype as corresponding expression


Solutions on the web6319

Solution icon of oraclecommunity
via Oracle Community by 640988, 1 year ago
ORA-01790: expression must have same datatype as corresponding expression

Solution icon of oraclecommunity
ORA-01790: expression must have same datatype as corresponding expression

Solution icon of oraclecommunity
via Oracle Community by 640988, 1 year ago
ORA-01790: expression must have same datatype as corresponding expression

Solution icon of oraclecommunity
via Oracle Community by 632265, 1 year ago
ORA-01790: expression must have same datatype as corresponding expression

Solution icon of coderanch
via Coderanch by chundottu jacob, 8 months ago
ORA-00936: missing expression

Solution icon of hibernate
via Hibernate JIRA by Roland Scheel, 1 year ago
ORA-00936: missing expression

Solution icon of hibernate
via Hibernate JIRA by Dytech Solutions, 1 year ago
ORA-00936: missing expression

Solution icon of oraclecommunity
via Oracle Community by 707755, 1 year ago
ORA-00936: missing expression

Solution icon of oraclecommunity
via Oracle Community by 843859, 8 months ago
ORA-00936: missing expression

Solution icon of oraclecommunity
via Oracle Community by 843859, 8 months ago
ORA-00936: missing expression

Stack trace

  • java.sql.SQLException: ORA-01790: expression must have same datatype as corresponding expression at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:212) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:795) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1030) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:835) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1123) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3284) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3328) at com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:347) at com.solarmetric.jdbc.PoolConnection$PoolPreparedStatement.executeQuery(PoolConnection.java:343) at com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:345) at com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:345) at com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:345) at com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1094) at com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:345) at kodo.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1633) at com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:332) at kodo.jdbc.sql.Union.execute(Union.java:425) at kodo.jdbc.sql.Union.execute(Union.java:332) at kodo.jdbc.sql.Union.execute(Union.java:313) at kodo.jdbc.sql.SelectImpl.addEagerResults(SelectImpl.java:386) at kodo.jdbc.sql.SelectImpl.execute(SelectImpl.java:350) at kodo.jdbc.sql.SelectImpl.execute(SelectImpl.java:301) at kodo.jdbc.sql.Union$UnionSelect.execute(Union.java:642) at kodo.jdbc.sql.Union.execute(Union.java:326) at kodo.jdbc.sql.Union.execute(Union.java:313) at kodo.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:98)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 10 months ago
Samebug visitor profile picture
Unknown user
Once, 11 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
76 more bugmates