【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沒有訪問許可權,導致報錯。
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沒有訪問許可權,導致報錯。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22664653/viewspace-687898/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- PL/SQL 學習日記SQL
- [PL/SQL]10g PL/SQL學習筆記(一)SQL筆記
- [PL/SQL]10g PL/SQL學習筆記(二)SQL筆記
- [PL/SQL]10g PL/SQL學習筆記(三)SQL筆記
- 【PL/SQL 學習】隱式遊標學習SQL
- PL/SQL學習筆記-1SQL筆記
- PL/SQL學習筆記-2SQL筆記
- PL/SQL學習筆記-3SQL筆記
- PL/SQL學習筆記-4SQL筆記
- PL/SQL學習筆記-5SQL筆記
- PL/SQL學習筆記-6SQL筆記
- PL/SQL學習筆記-總結SQL筆記
- Oracle之PL/SQL基礎學習OracleSQL
- pl/sql練習SQL
- pl/sql 練習SQL
- PL/Sql循序漸進全面學習教程--OracleSQLOracle
- Oracle之PL/SQL基礎學習之二OracleSQL
- PL/SQL經典學習筆記(6-10)SQL筆記
- PL/SQL經典學習筆記(2-5)SQL筆記
- oracle學習筆記(十七) PL/SQL高階應用Oracle筆記SQL
- 有關使用PL/SQL提高效能的學習:SQL
- oracle學習筆記(十五) PL/SQL語法結構以及使用Oracle筆記SQL
- PL/SQLSQL
- OCP 複習筆記之PL/SQL (3)筆記SQL
- OCP 複習筆記之PL/SQL (5)筆記SQL
- OCP 複習筆記之PL/SQL (1)筆記SQL
- OCP 複習筆記之PL/SQL (4)筆記SQL
- OCP 複習筆記之PL/SQL (2)筆記SQL
- SQL&PL/SQL (轉)SQL
- PL/SQL 宣告SQL
- PL/SQL cursorSQL
- PL/SQL打包SQL
- PL/SQL DEVSQLdev
- Oracle PL/SQLOracleSQL
- 使用PL/Scope分析PL/SQL程式碼SQL
- PLSQL Language Reference-PL/SQL概覽-PL/SQL架構SQL架構
- pl/sql developer中關於TIMESTAMP顯示格式的疑問和學習SQLDeveloper
- PL/SQL 迴圈SQL