2478359 - ORA-04063: package body "SYS.DBMS_STATS_INTERNAL" has errors

Symptom

You received an ABAP Dump with UNCAUGHT_EXCEPTION for the ABAP program CL_SDB_ORA_UPDATE_STATS=======CP
The ABAP dump shows the following errors as the cause of the exception:

ORA-04063: package body "SYS.DBMS_STATS_INTERNAL" has errors

ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STATS_INTERNAL"

ORA-06512: at "SYS.DBMS_STATS", line 2045

ORA-06512: at "SYS.DBMS_STATS", line 2073

ORA-0651...

When you try to compile DBMS_STATS_INTERNAL, you get a warning:

SQL> alter package DBMS_STATS_INTERNAL compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors;

Errors for PACKAGE BODY DBMS_STATS_INTERNAL:

7286/5 PL/SQL: Statement ignored

7286/29 PLS-00302: component 'PURGE_ALL' must be declared

The status of the package body DBMS_STATS_INTERNAL is INVALID:

SQL> select object_name, object_type, status from dba_objects where owner = 'SYS' AND status <> 'VALID';

OBJECT_NAME OBJECT_TYPE STATUS
-------------------------------------------------------
DBMS_STATS_INTERNAL PACKAGE BODY INVALID

Environment

SAP Systems based on SAP NetWeaver
Oracle Database

Product

SAP NetWeaver all versions

Keywords

CX_SDB_ORA_PROGRAM_ERROR, CL_SQL_STATEMENT==============CM008, UNCAUGHT_EXCEPTION, CX_SDB_ORA_PROGRAM_ERROR, CL_SDB_ORA_UPDATE_STATS=======CP, CL_SDB_ORA_UPDATE_STATS=======CM00I, UPDATE_STATS, ora, 04063, 4063, ora-4063 , KBA , BC-DB-ORA-CCM , (CCMS) Database Monitors , 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.