Invalid Objects (Errors PLS-00201 and PLS-00320) Caused by UTL_FILE Permissions
(Doc ID 432961.1)
Last updated on OCTOBER 31, 2019
Applies to:Oracle OLAP - Version 10.2.0.4 and later
Oracle Data Mining - Version 10.2.0.4 and later
Information in this document applies to any platform.
Several objects in (for example) the OLAPSYS and DMSYS schemas are flagged as invalid, as shown below:
where status <> 'VALID' and owner IN ('OLAPSYS','DMSYS');
The output reports the following objects:
Try to recompile a package manually to see if this is the issue at hand:
as well as Statement ignored and Item ignored entries.SQL>alter package olapsys.dbms_odm compile body; Warning: Package Body altered with compilation errors. SQL>show errors PLS-00201: identifier 'UTL_FILE' must be declared PLS-00320: the declaration of the type of expression is incomplete or malformed
One of the following:
- Applied patches to the instance.
- Installed new components (using scripts or Oracle Installer)
- Execute <ORACLE_HOME>/rdbms/admin/utlrp.sql
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document