New Note 1459045.1 11.5.10.2 Maintenance Pack 3480000 Failed On Sript Asocruhk.sql ORA-04063: packag
While applying maintenance pack Patch 3480000, the following error occurs:
sqlplus -s APPS/***** @/.../aso/11.5.0/patch/115/sql/asocruhk.sql
DECLARE
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "APPS.JTF_USR_HKS" has errors
ORA-06512: at line 57
ORA-06512: at line 128
DECLARE
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "APPS.JTF_USR_HKS" has errors
ORA-06512: at line 57
ORA-06512: at line 128
Manual attempt to compile .JTF_USR_HKS fails.
SQL> alter package JTF_USR_HKS compile body;
Warning: Package Body altered with compilation errors.
SQL> sho err
Errors for PACKAGE BODY JTF_USR_HKS:
LINE/COL ERROR
-------- -----------------------------------------------------------------
931/3 PLS-00201: identifier 'XMLGEN.CLEARBINDVALUES' must be declared
931/3 PL/SQL: Statement ignored
935/3 PLS-00201: identifier 'XMLGEN.SETBINDVALUE' must be declared
SQL> sho err
Errors for PACKAGE BODY JTF_USR_HKS:
LINE/COL ERROR
-------- -----------------------------------------------------------------
931/3 PLS-00201: identifier 'XMLGEN.CLEARBINDVALUES' must be declared
931/3 PL/SQL: Statement ignored
935/3 PLS-00201: identifier 'XMLGEN.SETBINDVALUE' must be declared
Tagged:
0