【PL/SQL 学习】PLS-00201

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没有访问权限,导致报错。
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值