SAP Knowledge Base Article - Preview

3667007 - Invalid object PACKAGE BODY DBMS_LOGMNR_INTERNAL - NetWeaver

Symptom

  • Invalid object in the database named PACKAGE BODY DBMS_LOGMNR_INTERNAL.

SQL> select object_name,object_type,owner ,status from dba_objects where object_name='DBMS_LOGMNR_INTERNAL';

OBJECT_NAME                                                OBJECT_TYPE             OWNER    STATUS
---------------------------------------------------   ------------------           -------      -------
DBMS_LOGMNR_INTERNAL                                 PACKAGE                 SYS         VALID
DBMS_LOGMNR_INTERNAL                             PACKAGE BODY            SYS         INVALID

  • Show errors for package body DBMS_LOGMNR_INTERNAL. There is error ORA-00904: "SAI"."PDBUID": invalid identifier.

SQL> show errors package body DBMS_LOGMNR_INTERNAL

 Errors for PACKAGE BODY DBMS_LOGMNR_INTERNAL:

LINE/COL ERROR
-------- -----------------------------------------------------------------
10767/3  PL/SQL: SQL Statement ignored
10835/35 PL/SQL: ORA-00904: "SAI"."PDBUID": invalid identifier


Read more...

Environment

SAP NetWeaver on Oracle database 19c

Product

SAP NetWeaver 7.5

Keywords

DBMS_LOGMNR_INTERNAL,PACKAGE BODY,ORA-00904,"SAI"."PDBUID": invalid identifier,INVALID,PDBUID , 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.