Search Results dbms_xdbutil_int




Overview
Explore in AI Chat

Overview

DBMS_XDBUTIL_INT is an internal PL/SQL package owned by the XDB schema and shipped as part of the Oracle XML DB component that underpins every Oracle E-Business Suite 12.1.1 and 12.2.2 installation. The package is classified as an OTHER-type API in the ETRM repository; it is not a supported application programming interface and is not intended for direct invocation by EBS developers. Its business function is to provide the low-level utility layer that XML DB uses to register, validate, and maintain the XML schemas, resources, and repository objects on which EBS features such as the XML Gateway, BI Publisher bursting, and the OAF attachment infrastructure depend. In effect, DBMS_XDBUTIL_INT is the plumbing that allows XML DB to bootstrap and patch its own metadata without circular dependency failures during database creation, upgrade, and patching.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents zero public procedures or functions for this package, which is consistent with its role as an internal implementation package. Its callable surface is deliberately undocumented and subject to change between XML DB patch levels. Functionally, the package exposes the helper routines used by XML DB to construct and validate schema objects, resolve XMLType references, and manage temporary job and status descriptors during schema registration. External code should treat DBMS_XDBUTIL_INT as a black box; any reliance on its entry points risks breakage when the database is patched or upgraded.

Tables Accessed

The documented dependency list shows the package reading from or referencing XMLTYPE, ALL_SEQUENCES, ALL_TRIGGERS, and ALL_USERS, together with the DBMS_ASSERT, DBMS_DATAPUMP, DBMS_LOB, DBMS_OUTPUT, DBMS_SQL, and DBMS_XDBZ built-ins. It also touches the data dictionary views KU$_JOBDESC and KU$_STATUS, DUAL, and the PLITBLM PL/SQL table type. The dictionary tables are used for schema-existence and trigger validation checks that occur when XML schemas are registered or refreshed — for example, confirming that a target user or sequence exists before an XML DB resource is published. DBMS_DATAPUMP and the KU$ job/status views support the bulk import and export of XML DB repository content, while DBMS_XDBZ supplies the repository-access-control logic that governs which EBS schema may read or write a given resource.

Usage Notes

DBMS_XDBUTIL_INT is invoked indirectly rather than from EBS forms or concurrent programs. It is called by the XML DB itself and by the higher-level packages listed in the dependency report — DBMS_CSX_ADMIN, DBMS_CSX_INT, DBMS_XDBZ, DBMS_XDB_ADMIN, and XDB$PATCHUPSCHEMA — whenever XML schemas are installed, repository resources are created or migrated, or the XML DB component is patched. The public wrapper DBMS_XDBUTIL_INT is exposed to PUBLIC, so the name may appear in dependency trees during EBS patching diagnostics. Because the package is internal, unsupported, and owned by XDB rather than APPS, it must never be modified, recompiled manually, or called from custom EBS code. Administrators encountering INVALID status on this object should resolve the condition through standard XML DB recompilation or Oracle patch application, not through direct DDL.