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 for Me (Login required).

Search for additional results

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