XDB is Invalid and XDB.DBMS_XDBZ0 package body fails to compile with the error PLS-00593. (Doc ID 2855493.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

 XDB is Invalid due to XDB.DBMS_XDBZ0 package body is Invalid.

 When compile XDB.DBMS_XDBZ0 package body manually which fails with the following error.

SQL> ALTER PACKAGE XDB.DBMS_XDBZ0 COMPILE BODY ;

Warning: Package Body altered with compilation errors.

SQL> show error;
Errors for PACKAGE BODY XDB.DBMS_XDBZ0:

LINE/COL
---------------------------------------------------------------------------------
ERROR
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
244/4
PLS-00593: default value of parameter "HIERARCHY_TYPE" in body must match that of spec

610/38
PLS-00593: default value of parameter "HIERARCHY_TYPE" in body must match that of spec

824/40
PLS-00593: default value of parameter "HIERARCHY_TYPE" in body must match that of spec

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.