Oracle | PRVT_DBMS_MANAGE

Oracle PRVT_DBMS_MANAGE_XMLSTORAGE Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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;