Several Invalid Objects Noticed After Upgrading From 4.5.3 to 4.6.2 Using RDBMS 12c
(Doc ID 2118292.1)
Last updated on FEBRUARY 11, 2019
Applies to:
Oracle Clinical - Version 4.5.3 to 4.6.2 [Release 4.5.3 to 4.6.2]Information in this document applies to any platform.
Symptoms
While using RDBMS 12c, the upgrade from 4.5.3 to 4.6.2 appears to complete successfully however several invalid objects remaining after the upgrade.
Errors for PACKAGE BODY RXC.RDC_ZF_DCI_ACCESS:
55/4 PL/SQL: SQL Statement ignored
55/29 PL/SQL: ORA-01031: insufficient privileges
Errors for PACKAGE BODY RXC.TRACKACTIVITIES:
0/0 PL/SQL: Compilation unit analysis terminated
1/18 PLS-00201: identifier 'TRACKACTIVITIES' must be declared
1/18 PLS-00304: cannot compile body of 'TRACKACTIVITIES' without its Specification
Errors for PACKAGE BODY RXC.RXC_DCI_BOOK_RULES_API:
0/0 PL/SQL: Compilation unit analysis terminated
1/18 PLS-00201: identifier 'RXC_DCI_BOOK_RULES_API' must be declared
1/18 PLS-00304: cannot compile body of 'RXC_DCI_BOOK_RULES_API' without its specification
Errors for PACKAGE BODY RXC.RDC_REPORT_XML_GENERATION:
4428/3 PL/SQL: Statement ignored
4428/33 PLS-00201: identifier
'RXC_RESPONSE_LOBS.FETCH_RESPONSE_VERSION_LOB' must be declared
4454/3 PL/SQL: Statement ignored
4454/33 PLS-00201: identifier
'RXC_RESPONSE_LOBS.FETCH_RESPONSE_CURRENT_LOB' must be declared
Errors for PACKAGE BODY RXC_REP.REPLINVSITE:
168/5 PL/SQL: SQL Statement ignored
193/12 PL/SQL: ORA-00904: "EXPECTED_ENROLLMENT_RATE": invalid identifier
Errors for TRIGGER RXA_DES.PATIENT_STATUSES$ARI:
2/20 PL/SQL: Item ignored
2/20 PLS-00201: identifier 'RXA_DES.PATIENT_POSITION_TY' must be
declared
10/3 PL/SQL: SQL Statement ignored
10/10 PL/SQL: ORA-00904:
"RXA_DES"."PATIENT_POSITIONS_PCK"."CREATE_PATIENT_POSITION_PS":
invalid identifier
62/3 PL/SQL: Statement ignored
62/6 PLS-00320: the declaration of the type of this expression is incomplete or malformed
Changes
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! |