Oracle 12cR2 PRVTPARENTCHILD

Oracle PRVTPARENTCHILD Version 12.2.0.1

General Information

Library Note

Morgan's Library Page Header

Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.

Purpose Undocumented

AUTHID DEFINER

Data Types TYPE refCursor is REF CURSOR;

Dependencies

ALL_XML_SCHEMA_ELEMENTS	PLITBLM	XDB$ELEMENT
DBA_XML_SCHEMA_ELEMENTS	USER_XML_SCHEMA_ELEMENTS	XDB$GROUP_DEF
DBMS_ASSERT	XDB$ALL_MODEL	XDB$GROUP_REF
DBMS_OUTPUT	XDB$CHOICE_MODEL	XDB$SEQUENCE_MODEL
PARENTIDARRAY

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/catvxutil.sql

Subprograms

GETPARENTID

SIZEARRAY

GETPARENTID

Undocumented prvtparentchild.getParentID(elementID IN VARCHAR2) RETURN PARENTIDARRAY;

SQL>
      
      SELECT prvtparentchild.getParentID(11)

        2  FROM dual;

      

      PRVTPARENTCHILD.GETPARENTID(11)

      -------------------------------

      PARENTIDARRAY('10')

SIZEARRAY

Undocumented prvtparentchild.sizeArray(elementID IN VARCHAR2) RETURN NUMBER;

SQL> SELECT prvtparentchild.sizearray(11)

        2  FROM dual;

      

      PRVTPARENTCHILD.SIZEARRAY(11)

      -----------------------------

                                  1