EB Invalid objects: 11.5.10.2 to 12.1.3 upgrade - Linux x86-64
Michael says:Invalid objects After upgrading from 11.5.10.2 to 12.1.3
VIEW EB_AR_CUSTOMERS_V
PACKAGE BODY EB_PARTY_CUSTOMER_PVT
VIEW EB_AR_CUSTOMERS_V
PACKAGE BODY EB_PARTY_CUSTOMER_PVT
***********************************************************
SQL> alter view EB_AR_CUSTOMERS_V compile;
Warning: View altered with compilation errors.
SQL> show error;
Errors for PACKAGE BODY ARP_STAX_MINUS99:
LINE/COL ERROR
-------- -----------------------------------------------------------------
370/9 PLS-00341: declaration of cursor 'SEL_CC' is incomplete or
malformed
371/9 PL/SQL: SQL Statement ignored
384/16 PL/SQL: ORA-00942: table or view does not exist
387/25 PL/SQL: Item ignored
393/9 PL/SQL: SQL Statement ignored
393/27 PLS-00320: the declaration of the type of this expression is
VIEW EB_AR_CUSTOMERS_V
PACKAGE BODY EB_PARTY_CUSTOMER_PVT
VIEW EB_AR_CUSTOMERS_V
PACKAGE BODY EB_PARTY_CUSTOMER_PVT
***********************************************************
SQL> alter view EB_AR_CUSTOMERS_V compile;
Warning: View altered with compilation errors.
SQL> show error;
Errors for PACKAGE BODY ARP_STAX_MINUS99:
LINE/COL ERROR
-------- -----------------------------------------------------------------
370/9 PLS-00341: declaration of cursor 'SEL_CC' is incomplete or
malformed
371/9 PL/SQL: SQL Statement ignored
384/16 PL/SQL: ORA-00942: table or view does not exist
387/25 PL/SQL: Item ignored
393/9 PL/SQL: SQL Statement ignored
393/27 PLS-00320: the declaration of the type of this expression is
Tagged:
0