'ORA-00932: Inconsistent Datatypes: Expected - Got CLOB' Error in Data Entry Form (DEFQ)
Last updated on NOVEMBER 01, 2017
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms