How to validate the packages DBMS_METADATA_INT and DBMS_METADATA_UTIL
How to validate the packages DBMS_METADATA_INT and DBMS_METADATA_UTIL
Goal
The following objects were found invalid while querying dba_objects:
OWNER OBJECT_NAME OBJECT_TYPE STATUS
---------- ------------------------------ ------------------- -------
SYS DBMS_METADATA_INT PACKAGE BODY INVALID
SYS DBMS_METADATA_UTIL PACKAGE BODY INVALID
When trying to compile manually, you get the following errors:
SQL> alter package sys.dbms_metadata_util compile;
SP2-0809: Package altered with compilation warnings
SQL> show errors;
Errors for PACKAGE SYS.DBMS_METADATA_UTIL:
LINE/COL ERROR
-------- -----------------------------------------------------------------
130/9 PLW-06010: keyword "VALUE" used as a defined name
158/31 PLW-06010: keyword "TYPE" used as a defined name
211/17 PLW-06010: keyword "LENGTH" used as a defined name
214/17 PLW-06010: keyword "ROW" used as a defined name
229/17 PLW-06010: keyword "LENGTH" used as a defined name
232/17 PLW-06010: keyword "ROW" used as a defined name
245/17 PLW-06010: keyword "LENGTH" used as a defined name
248/17 PLW-06010: keyword "ROW" used as a defined name
261/17 PLW-06010: keyword "LENGTH" used as a defined name
264/17 PLW-06010: keyword "ROW" used as a defined name
281/17 PLW-06010: keyword "LENGTH" used as a defined name
Solution
Please run the following script which will re-create those packages and type bodies :
$ORACLE_HOME/rdbms/admin/catpprvt.sql
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-1063618/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- How to prevent your jar packages from being decompiled?JARPackageCompile
- python modules and packagesPythonPackage
- Linux Packages SearchLinuxPackage
- Types of SAP Support PackagesPackage
- VALIDATE STRUCTUREStruct
- 每日一個 Golang PackagesGolangPackage
- nuget packages batch installPackageBAT
- Session State and Referenced Packages (246)SessionPackage
- jQuery Validate success()jQuery
- Jquery--ValidatejQuery
- PL/SQL Packages DBMS_STATSSQLPackage
- jQuery Validate addMethod()jQuery
- jQuery Validate errorPlacement()jQueryError
- jQuery Validate optional()方法jQuery
- jQuery Validate invalidHandler()jQuery
- 學習VALIDATE STRUCTUREStruct
- npm publish gives “unscoped packages cannot be private”NPMPackage
- revoke EXECUTE privileges on powerful packages from PUBLICPackage
- Software Packages in `experimental' - 安裝方法(轉)Package
- Vue Element校驗validateVue
- jQuery Validate的format()用法jQueryORM
- jquery validate用法總結jQuery
- jQuery.validate 詳解jQuery
- jquery validate 詳解一jQuery
- jquery validate 詳解二jQuery
- 每日一個 Golang Packages 06/11 syncGolangPackage
- 每日一個 Golang Packages 06/12 fmtGolangPackage
- 每日一個 Golang Packages 06/09 mathGolangPackage
- 每日一個 Golang Packages 06/04 timeGolangPackage
- Unofficial Windows Binaries for Python Extension PackagesWindowsPythonPackage
- dart系列之:在dart中使用packagesDartPackage
- lerna管理前端packages的最佳實踐前端Package
- jQuery Validate highlight()jQuery
- jQuery Validate簡單介紹jQuery
- Leetcode-Validate BSTLeetCode
- jquery validate 手工驗證方法jQuery
- struts 自定義validate 問題
- win10怎麼刪除local packages資料夾_win10如何清理local packages資料夾Win10Package