Custom R2 Template Throws ORA-00932: Inconsistent Datatypes: Expected - Got CLOB Error
Last updated on DECEMBER 13, 2017
Applies to:Oracle Argus Interchange - Version 8.1.1 and later
Information in this document applies to any platform.
Oracle Argus Safety Version 8.1.1
Some E2B R2 reports created using custom templates do not run any more and throw below error:
Cause is located to be due to the fact that during upgrade from Argus 7.0.4 to Argus 8.1.1 several fields in the database have been changed from VARCHAR2 to CLOB.
These fields are used in custom templates in the cfg_e2b table.
It is a major effort to update all SQL statements in the AE_SELECT_STMT column.
Question, What did Oracle do for the standard templates? Have they been simply replaced by SQL statements with dbms_lob.substr() instead of ?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms