Oracle PRVT_DBMS_MANAGE_XMLSTORAGE
Version 19c

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;

Related Topics
Built-in Functions
Built-in Packages
What's New In 19c
What's New In 20c-21c

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