Oracle DBMS_XMLINDEX0
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows
Purpose Supporting package for DBMS_XMLINDEX
AUTHID CURRENT_USER
Dependencies
DBMS_XMLINDEX XMLINDEX_LIB  
Documented No
First Available Not Known
Security Model Owned by XDB with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/prvtxidx.plb
Subprograms
 
CREATEDATEINDEX
Appears to be the support for the corresponding DBMS_XMLINDEX procedure dbms_xmlindex0.createDateIndex(
xml_index_schema  IN VARCHAR2,
xml_index_name    IN VARCHAR2,
date_index_name   IN VARCHAR2,
xmltypename       IN VARCHAR2,
date_index_clause IN VARCHAR2,
column_name       IN VARCHAR2);
TBD
 
CREATENUMBERINDEX
Appears to be the support for the corresponding DBMS_XMLINDEX procedure dbms_xmlindex0.createNumberIndex(
xml_index_schema IN VARCHAR2,
xml_index_name   IN VARCHAR2,
num_index_name   IN VARCHAR2,
num_index_clause IN VARCHAR2,
xmltypename      IN VARCHAR2,
column_name      IN VARCHAR2);
TBD
 
GETPARAMETERNAME
Undocumented dbms_xmlindex0.getParameterName(paramstr IN VARCHAR2) RETURN VARCHAR2;
SELECT xdb.dbms_xmlindex0.getParameterName('Test');

XDB.DBMS_XMLINDEX0.GETPARAMETERNAME('TEST')
-------------------------------------------

 
 
RELOAD_SXI_LEAF
Reloads a Structured XML Index

Note: Unstructured SXI are deprecated in 26ai and superseded by XML Search indexes
dbms_xmlindex0.reload_sxi_leaf(
xml_index_schema IN VARCHAR2,
xml_index_name   IN VARCHAR2);
exec xdb.dbms_xmlindex0.reload_sxi_leaf(USER, 'IX_XML');

PL/SQL procedure successfully completed.

Related Topics
Built-in Functions
Built-in Packages
DBMS_XMLINDEX
What's New In 21c
What's New In 26ai

Morgan's Library Page Footer
This site is maintained by Daniel Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2026 Daniel A. Morgan All Rights Reserved