Transformation Installation Failure: " ORA-01790: expression must have same datatype as corresponding expression"
(Doc ID 2559189.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Data Management Workbench - Version 2.4.8 and laterInformation 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
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 |