Groovy Script Execution in ODI 12.2.1.3 Causes "ORA-00932: inconsistent datatypes: expected - got CLOB" Error Due to Distinct SQL Statement (Doc ID 2345082.1)

Last updated on JUNE 07, 2022

Applies to:

Symptoms

When trying to execute a Groovy script via Oracle Data Integrator (ODI) 12.2.1.3, the following error stack is encountered:

ODI-10182: Uncategorized exception during repository access.
ORA-00932: inconsistent datatypes: expected - got CLOB
(Subtract 18 from the error line number to account for the standard imports)
oracle.odi.core.repository.UncategorizedRepositoryAccessException: ODI-10182: Uncategorized exception during repository access.
ORA-00932: inconsistent datatypes: expected - got CLOB
  at oracle.odi.core.repository.RepositoryAccessExceptionTranslator.translateSpringException(RepositoryAccessExceptionTranslator.java:240)
  at oracle.odi.core.repository.RepositoryAccessExceptionTranslator.translateSQLException(RepositoryAccessExceptionTranslator.java:195)
  at oracle.odi.core.repository.RepositoryAccessExceptionTranslator.translateEclipseLinkException(RepositoryAccessExceptionTranslator.java:147)
  at oracle.odi.core.repository.RepositoryAccessExceptionTranslator.translateExceptionIfPossible(RepositoryAccessExceptionTranslator.java:113)
  at oracle.odi.core.persistence.jpa.JpaOdiEntityManager.translateDataAccessException(JpaOdiEntityManager.java:353)
  at oracle.odi.core.persistence.jpa.toplink.JpaTopLinkOdiEntityManager.readAll(JpaTopLinkOdiEntityManager.java:207)
  at oracle.odi.core.persistence.jpa.toplink.JpaTopLinkOdiEntityManager.readAll(JpaTopLinkOdiEntityManager.java:192)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  ...
Caused by: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got CLOB
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495)
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:447)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1055)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:624)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:253)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:613)
  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:227)
  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:60)
  at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:748)
  at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:965)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1157)
  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3833)
  at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1344)
  at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3875)
  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1166)
  at sun.reflect.GeneratedMethodAccessor70.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  ...
Caused by: Error : 932, Position : 526, Sql = <SQL_STATEMENT>, Error Msg = ORA-00932: inconsistent datatypes: expected - got CLOB
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:499)
... 74 more
Script exited.

Changes

 An upgrade has occurred from a previous version of ODI to ODI 12.2.1.3.

Cause

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