Search Results dbms_xmlschema




Overview
Explore in AI Chat

Overview

The XDB.DBMS_XMLSCHEMA package is the Oracle XML DB supplied PL/SQL interface for managing XML Schema definitions within the database. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, it resides in the XDB schema with a status of VALID and is exposed to the applications tier through a public synonym. Its principal business function is to register, validate, evolve, and delete XML schemas that underpin XML-typed columns, XMLType storage, and structured XML processing. Because EBS releases depend heavily on XML payloads for interfaces, Business Event subscriptions, Oracle Procurement, iSupplier, and HRMS integrations, this package provides the low-level XML DB capability that allows EBS objects to persist and validate conformant XML documents. It is classified as an OTHER API in the ETRM repository, indicating that it is not an EBS-supported business API but rather an Oracle XML DB infrastructure component that EBS inherits.

Key Procedures and Functions

The ETRM metadata documents eighteen callable objects, of which the following are the core surface. REGISTERSCHEMA registers a schema identified by a target URL, making it available to XML DB for validation and XMLType annotation. REGISTERURI registers a schema referenced indirectly by a URI, supporting schema imports and includes. DELETESCHEMA removes a previously registered schema, subject to dependency checks. PURGESCHEMA clears cached schema data. COMPILESCHEMA validates and compiles a registered schema so that its types and elements become usable. GENERATESCHEMA and GENERATESCHEMAS reverse-engineer schema text from existing XMLType instances or tables. GENERATEBEAN produces Java bean source for a schema, supporting middle-tier XML processing. COPYEVOLVE and INPLACEEVOLVE apply schema evolution so that existing XML data can conform to a revised schema. The conversion helpers CONVERTTODATE, CONVERTTOTS, and CONVERTTOTSWITHTZ translate schema lexical date and timestamp values into Oracle DATE and TIMESTAMP representations.

Tables Accessed

Dependency analysis shows that the package reads and writes the XML DB dictionary objects XMLTYPE and XMLSEQUENCETYPE, which hold schema-annotated XML data and sequencing information respectively. It also references DBMS_LOB for large object handling of schema documents and NLS_DATABASE_PARAMETERS to resolve territory and language settings that affect date, timestamp, and encoding conversions. Through the APPS synonym layer these objects are reachable from EBS sessions. The package additionally depends on SYS.STANDARD and exposes DBMS_XMLSCHEMA publicly for downstream consumers.

Usage Notes

In EBS 12.1.1 and 12.2.2, XDB.DBMS_XMLSCHEMA is invoked indirectly rather than through standard concurrent programs. Typical invocations occur when XMLType tables and columns are created during patching, when XML Gateway or Business Event mappings require schema validation, and within custom PL/SQL that registers schemas prior to inserting XML payloads. It is referenced by zero other documented packages, so direct calls originate from custom code, installation scripts, or Oracle XML DB internal routines. Technical consultants should call it only in a maintenance window, ensure the schema URL matches the intended target, and verify NLS and DBMS_LOB availability before registration.