aliim@im1>ALTER PACKAGE IM_UTL COMPILE BODY;
Warning: Package Body altered with compilation errors.
aliim@im1>SHOW ERROR
Errors for PACKAGE BODY IM_UTL:
LINE/COL ERROR
-------- -----------------------------------------------------------------
356/15 PLS-00201: identifier 'AREA_LIST' must be declared
356/15 PL/SQL: Item ignored
357/17 PLS-00201: identifier 'AREA_LIST' must be declared
357/17 PL/SQL: Item ignored
363/5 PL/SQL: SQL Statement ignored
363/95 PL/SQL: ORA-00942: table or view does not exist
365/5 PL/SQL: Statement ignored
365/9 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
370/5 PL/SQL: Statement ignored
370/9 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
aliim@im1>alter view &viewname compile;
Enter value for viewname: alter view &viewname compile;
old 1: alter view &viewname compile
new 1: alter view alter view &viewname compile; compile
alter view alter view &viewname compile; compile
*
ERROR at line 1:
ORA-00999: invalid view name
aliim@im1>/
Enter value for viewname: V_AREA_LIST
old 1: alter view &viewname compile
new 1: alter view V_AREA_LIST compile
Warning: View altered with compilation errors.
aliim@im1>show error
No errors.
aliim@im1>
解决办法重新赋予 aliim select any table 权限,这里查出 aliim对 AREA_LIST没有访问权限,导致报错。
Warning: Package Body altered with compilation errors.
aliim@im1>SHOW ERROR
Errors for PACKAGE BODY IM_UTL:
LINE/COL ERROR
-------- -----------------------------------------------------------------
356/15 PLS-00201: identifier 'AREA_LIST' must be declared
356/15 PL/SQL: Item ignored
357/17 PLS-00201: identifier 'AREA_LIST' must be declared
357/17 PL/SQL: Item ignored
363/5 PL/SQL: SQL Statement ignored
363/95 PL/SQL: ORA-00942: table or view does not exist
365/5 PL/SQL: Statement ignored
365/9 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
370/5 PL/SQL: Statement ignored
370/9 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
aliim@im1>alter view &viewname compile;
Enter value for viewname: alter view &viewname compile;
old 1: alter view &viewname compile
new 1: alter view alter view &viewname compile; compile
alter view alter view &viewname compile; compile
*
ERROR at line 1:
ORA-00999: invalid view name
aliim@im1>/
Enter value for viewname: V_AREA_LIST
old 1: alter view &viewname compile
new 1: alter view V_AREA_LIST compile
Warning: View altered with compilation errors.
aliim@im1>show error
No errors.
aliim@im1>
解决办法重新赋予 aliim select any table 权限,这里查出 aliim对 AREA_LIST没有访问权限,导致报错。