XDB Component is Invalid due to XDB.DBMS_XDBT being Invalid (Doc ID 2853796.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

XDB Component is Invalid due to XDB.DBMS_XDBT object being Invalid.

Upon recompilation of XDB.DBMS_XDBT we have:

alter package XDB.DBMS_XDBT compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY XDB.DBMS_XDBT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
611/3    PL/SQL: Statement ignored
611/3    PLS-00201: identifier 'DBMS_SCHEDULER' must be declared

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.