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