SAP Knowledge Base Article - Preview

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

Read more...

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 for Oracle , 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.