My Oracle Support Banner

Custom R2 Template Throws ORA-00932: Inconsistent Datatypes: Expected - Got CLOB Error (Doc ID 2329206.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences 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

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
Goal
Solution
References


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