Custom R2 Template Throws ORA-00932: Inconsistent Datatypes: Expected - Got CLOB Error

(Doc ID 2329206.1)

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.

Goal

Oracle Argus Safety Version 8.1.1

Some E2B R2 reports created using custom templates do not run any more and throw below error:

"ORA-00932: inconsistent datatypes: expected - got CLOB" errors.


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 ?
 

Solution

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