Oracle | PRVT_DBMS_MANAGE

Oracle PRVT_DBMS_MANAGE_XMLSTORAGE Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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;