Validation Check Batch Installation Failed with Error "PARAM3=PL/SQL source code is not properly terminated. Failed to insert security code into the package."
(Doc ID 2796211.1)
Last updated on FEBRUARY 21, 2023
Applies to:Oracle Health Sciences Data Management Workbench - Version 2.5.3 and later
Information in this document applies to any platform.
On Oracle Data Management WorkBench (DMW) 2.5.3 version, Validation Check Batch Installation Fails with below error:
XFM_INSTALL:XXX:*** ERROR: Error during Workarea Install : &PARAM0 (PARAM2=Cdr_Exe_Installation) (PARAM3=PL/SQL source code is not properly terminated. Failed to insert security code into the package. The package should end with "END;" or "END <my_package>;")
XFM_INSTALL:XXX:*** ERROR: Error during Workarea Install : Please see the Installation log for detailed error information.
XFM_INSTALL:XXX:*** ERROR: There may be errors during work area installation for the target model. Please try re-deploying the map.
Error from OWB/CDR DB Server-PLSQL Operator: statement:"begin WORKAREA_SCHEMA.PLSQL_UTIL_PROG_PKG.PROCESSPLSQLUTILJOB ; end;" caught:java.sql.SQLException: ORA-20200: *** ERROR: Exception while Installing the VC Batch..Hence cannot proceed further
ORA-06512: at "APPS.CDR_ATK_UTILS", line 866
ORA-06512: at "APPS.DME_INST_XFORM_MAP", line 12768
ORA-06512: at "APPS.DME_DF_XFORM_MAP", line 23124
ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 15933
ORA-06512: at "CDR_WE7D_21021_1.PLSQL_UTIL_PROG_PKG", line 4
ORA-06512: at line 1
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