SAP Knowledge Base Article - Preview

2518374 - catsbp - PLS-00201: identifier 'UTL_FILE' must be declared

Symptom

  • You are executing catsbp script and it finishes with "Overall Status: INCOMPLETE".
  • catsbp finishes with the following INVALID objects:
SQL> select owner, object_name, object_id, object_type, created, last_ddl_time, timestamp, status from dba_objects where status != 'VALID' order by object_name;
OWNER OBJECT_NAME OBJECT OBJECT_TYPE CREATED LAST_DDL TIMESTAMP STATUS
XDB DBMS_CLOBUTIL <obj> PACKAGE <date> <date> <timestamp> INVALID
XDB DBMS_CLOBUTIL <obj> PACKAGE BODY <date> <date> <timestamp> INVALID
XDB DBMS_XDB_ADMIN <obj> PACKAGE BODY <date> <date> <timestamp> INVALID
XDB DBMS_XMLPARSER <obj> PACKAGE BODY <date> <date> <timestamp> INVALID
XDB DBMS_XSLPROCESSOR <obj> PACKAGE BODY <date> <date> <timestamp> INVALID
  • Error messages similar the following can be seen in the catsbp log file (related to the same invalid objects above):
PLS-00320: the declaration of the type of this expression is incomplete or malformed
PLS-00201: identifier 'UTL_FILE' must be declared
PLS-00905: object <invalid_object> is invalid
PL/SQL: Statement ignored
PL/SQL: Item ignored
  • You have tried to manually run the script @?/rdbms/admin/utlrp.sql but the objects are still invalid.

Read more...

Environment

  • SAP Systems based on SAP NetWeaver
  • Oracle Database

Product

SAP NetWeaver all versions

Keywords

KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.