Search Results dbms_xdbz0




Overview
Explore in AI Chat

Overview

XDB.DBMS_XDBZ0 is an Oracle-supplied, wrapped PL/SQL package that resides in the XDB schema and forms part of the Oracle XML DB security infrastructure. Within the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, this package is not an EBS-authored object but is delivered as a dependency of the Oracle database XML DB option, which EBS leverages for XML-based functionality, repository management, and fine-grained access control on XMLType data. The package is classified in the ETRM repository under the API classification OTHER, indicating it is a database-vendor utility rather than a formally published EBS application programming interface.

Its principal business function is the internal implementation of Oracle XML DB's security model, particularly the enforcement of access control lists, resource privileges, and row-level security policies applied to the XML DB repository and to XMLType storage. The "0" suffix convention in Oracle's dictionary namespace typically designates an internal or implementation-level package whose public-facing counterpart is exposed through a higher-level API. DBMS_XDBZ0 therefore provides the underlying machinery that higher-level XML DB security calls depend upon.

Key Procedures and Functions

The ETRM metadata for this object documents zero stored procedures or functions available for direct invocation. This is consistent with the package being a wrapped, internal implementation unit. The absence of documented entry points means administrators and developers should not call DBMS_XDBZ0 directly. Because the package body is wrapped, its internal routines are obfuscated by Oracle and are intended solely for consumption by other XML DB components. Attempting to reverse-engineer or invoke undocumented subprograms is unsupported and can compromise XML DB security or database stability.

Tables Accessed

Per the ETRM metadata, the package references the following objects through APPS synonyms: ALL_POLICIES, USER_POLICIES, DBMS_ASSERT, DBMS_RLS, DBMS_SQL, DUAL, and XMLTYPE. The policy-related views ALL_POLICIES and USER_POLICIES, together with the DBMS_RLS package, indicate that DBMS_XDBZ0 participates in Oracle's Virtual Private Database (VPD) and fine-grained access control framework. DBMS_SQL and DUAL support dynamic SQL execution and simple expression evaluation. DBMS_ASSERT provides input sanitization to guard against SQL injection in policy and privilege processing. XMLTYPE is referenced because the package operates directly against XML DB repository resources and XML-typed content. The presence of DBMS_ASSERT and DBMS_RLS confirms that this package is a security-sensitive component, and any diagnostic queries against its referenced objects should be read-only.

Usage Notes

DBMS_XDBZ0 is invoked indirectly rather than explicitly. In Oracle EBS, it is activated when the database XML DB option is configured and when applications or concurrent programs interact with XMLType data, XML DB repository paths, or access control entries. Administrators may observe the package in dependency trees, invalid-object reports, or ADOP and AutoConfig log output during patching and cloning. The metadata indicates the package is referenced by three other packages, reinforcing its role as a supporting dependency. The query string "ax d365 prod8 sjsho" that led to this object suggests an operational or integration search rather than a functional requirement; no linkage between this package and Microsoft Dynamics 365 or external systems exists. Standard practice is to ensure the object remains VALID after database upgrades and to avoid manual recompilation, as recompiling wrapped XML DB internals is unsupported.