'ORA-00932: Inconsistent Datatypes: Expected - Got CLOB' Error in Data Entry Form (DEFQ)
(Doc ID 2098570.1)
Last updated on AUGUST 25, 2020
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Analytical Applications (OFSAA) Infrastructure, when you open a Data Entry Form created for a table that has a column defined as CLOB, the Form fails to load and the following error appears:
ORA-00932: inconsistent datatypes: expected - got CLOB
The same error exists in the DeFiService.log from $FIC_APP_HOME/common/FICServer/logs:
[DEFILOG] Jan 19,16 14:28:24 : [ABSTRACTDATAENTRYREPOSITORY]ORA-00932: inconsistent datatypes: expected - got CLOB
java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got CLOB
In the definition of the Form, the CLOB column is among the columns selected for sorting.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document