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 laterInformation 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:
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 |