Oracle | DBMS_XMLINDEX0

Oracle DBMS_XMLINDEX0 Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

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	GETPARAMETERNAME	RELOAD_SXI_LEAF
CREATENUMBERINDEX

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.