We have migrated Appworx dev database from Solaris to new platform (Linux) and all objects are valid except the one mentioned below.
SQL> @/orabkup/orauksm1/scripts/chk_invalid.sql
COUNT(*)
----------
1
COUNT(*) OWNER
---------- --------------------------------------------------------------------------------------------------------------------------------
1 APPW_UK
SQL> alter package APPW_UK.AW_TOOLS compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY APPW_UK.AW_TOOLS:
791/1 PL/SQL: SQL Statement ignored
796/22 PL/SQL: ORA-00942: table or view does not exist
827/20 PL/SQL: SQL Statement ignored
832/27 PL/SQL: ORA-00942: table or view does not exist
836/13 PL/SQL: Statement ignored
836/18 PLS-00364: loop index variable 'Y' use is invalid
856/1 PL/SQL: SQL Statement ignored
860/74 PL/SQL: ORA-00942: table or view does not exist
867/1 PL/SQL: SQL Statement ignored
867/45 PL/SQL: ORA-00942: table or view does not exist
873/12 PL/SQL: Statement ignored
873/64 PLS-00364: loop index variable 'REC' use is invalid
874/9 PL/SQL: Statement ignored
874/17 PLS-00364: loop index variable 'REC' use is invalid
876/12 PL/SQL: Statement ignored
876/64 PLS-00364: loop index variable 'REC2' use is invalid
This package body is encrypted hence unable to view the code to identify the missing table/view/grant.
Has anyone encountered the similar issue?
Please help, let me know if you need any further details.
Regards
Pankaj