AnsweredAssumed Answered

Oralce DB Re-Platform

Question asked by PankajKV on Mar 19, 2019

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

Outcomes