Oracle | PRVT_DBMS_MANAGE

Oracle PRVT_DBMS_MANAGE_XMLSTORAGE 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 Undocumented

AUTHID DEFINER

Data Types TYPE xdb.xdb$xmltype_ref_list_t varray(2147483647) OF REF XMLTYPE;

Dependencies

DBMS_XMLSTORAGE_MANAGE	XDB$COMPLEX_TYPE	XDB$SEQUENCE_MODEL
DUAL	XDB$GROUP_DEF	XDB$XMLTYPE_REF_LIST_T
XDB$ALL_MODEL	XDB$GROUP_REF	XMLTYPE
XDB$CHOICE_MODEL	XDB$MODEL_T	XMLTYPE_REF_TABLE_T

Documented No

First Available 12.1

Security Model Owned by XDB with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/prvtxutil.plb

GETCOMPLEXTYPEELEMENTLIST

Undocumented
Overload 1 prvt_dbms_manage_xmlstorage.getComplexTypeElementList(p_complex_type_ref IN REF XMLTYPE) RETURN xdb$xmltype_ref_list_t;

TBD

Overload 2 prvt_dbms_manage_xmlstorage.getComplexTypeElementList( p_sqltype IN VARCHAR2, p_sqlschema IN VARCHAR2) RETURN xdb$xmltype_ref_list_t;

CREATE TABLE t(

      testcol xdb.xdb$xmltype_ref_list_t);

      

      DECLARE

       retVal xdb.xdb$xmltype_ref_list_t;

      BEGIN

        retVal := xdb.prvt_dbms_manage_xmlstorage.getComplexTypeElementList('new_values51_T', 'SYS');

        INSERT INTO t VALUES (retVal);

        COMMIT;

      END;

      /

      

      SELECT * FROM t;