My Oracle Support Banner

Transformation Installation Failure: " ORA-01790: expression must have same datatype as corresponding expression" (Doc ID 2559189.1)

Last updated on JULY 03, 2019

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.4.8 and later
Information in this document applies to any platform.

Symptoms

On DMW PROD : 2.4.8.0.28 a Transformation installation failure is encountered.

Per the  installation log, Transformation installation is failing with below error :

Checking for invalid source codes,synonyms in PG_10766771_PRG Program ( EX1001 )
Source code is invalid.Hence Recompiling the objects to resolve any compilation errors.
Program's Package Body is in invalid state.
Package Body has following errors at:
Line 4 with PL/SQL: SQL Statement ignored
Line 1139 with PL/SQL: ORA-01790: expression must have same datatype as corresponding expression

Error in DB : PL/SQL: ORA-01790: expression must have same datatype as corresponding expression



Cause

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
Symptoms
Cause
Solution


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