Oracle | DBMS_XDBUTIL

Oracle DBMS_XDBUTIL_INT 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 Internal XDB Utilities

AUTHID CURRENT_USER

Dependencies

ALL_SEQUENCES	DBMS_ASSERT	IS_VPD_ENABLED
ALL_TRIGGERS	DBMS_CSX_ADMIN	KU$_EXP_XMLSCHEMA_VIEW
ALL_USERS	DBMS_DATAPUMP	KU$_JOBDESC
ALL_XML_SCHEMAS	DBMS_LOB	KU$_STATUS
ALL_XML_SCHEMA_ATTRIBUTES	DBMS_OUTPUT	KU$_XMLSCHEMA_VIEW
ALL_XML_SCHEMA_COMPLEX_TYPES	DBMS_SQL	KU$_TTS_TYPES_VIEW
ALL_XML_SCHEMA_ELEMENTS	DBMS_STANDARD	KU$_XMLSCHEMA_TYPES_VIEW
ALL_XML_SCHEMA_NAMESPACES	DBMS_XDB	KU$_XMLSCHEMA_VIEW
ALL_XML_SCHEMA_SIMPLE_TYPES	DBMS_XDBUTIL_INT	KUPW$WORKER
ALL_XML_SCHEMA_SUBSTGRP_HEAD	DBMS_XDBZ	PLITBLM
ALL_XML_SCHEMA_SUBSTGRP_MBRS	DBMS_XDBZ0	USER_XML_SCHEMAS
CHECK_UPGRADE	DBMS_XDB_ADMIN	XDB$PATCHUPSCHEMA
DBA_XMLSCHEMA_LEVEL_VIEW	DBMS_XDB_LIB	XDB$SCHEMA
DBA_XMLSCHEMA_LEVEL_VIEW_DUP	DBMS_XMLDOM	XDB$STRING_LIST_T
DBA_XML_SCHEMAS	DBMS_XSLPROCESSOR	XMLSCHEMA_LIB
DBA_XML_SCHEMA_DEPENDENCY	DUAL	XMLTYPE
DBA_XML_SCHEMA_IMPORTS	GETXMLSCHEMADEPENDENCYLIST	XMLTYPEEXTRA
DBA_XML_SCHEMA_INCLUDES	GET_TABLE_NAME	XMLTYPEPI

Documented No

First Available Not known

Security Model Owned by XDB with EXECUTE granted to PUBLIC

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

Subprograms

CLEANSGAFORUPGRADE	GETNEWOID	NUMTOHEX2
CLEANUP_EXPIRED_NFSCLIENTS	GET_TABLESPACE_TAB	PATCHREPOSITORYRESCONFIGLIST
CREATEACL	IMPORTSEQUENCE	RAWTONUM
CREATECROSSCONFOLDER	INSTANCE_CALLOUT_IMP	RAWTONUM2
CREATESYSTEMVIRTUALFOLDER	INSTANCE_EXPORT_ACTION	SETLINKPARENTS
FIXACL	ISOBJECTGENERATED	SETLINKPARENTSNEW
FIXACL_DOWNGRADE	ISTABLEOUTOFLINE	SYSTEM_INFO_EXP
FLUSHSESSION	ISXMLNESTEDTABLE	USESETLINKPARENTSNEW
GETCOMPILEDSCHEMA	LOOKUPSCHEMAOID	XMLSCHEMADEPENDENCYLEVEL
GETCOMPILEDSCHEMABYID	LOOKUPSCHEMAURL	XMLSCHEMAGETDEPENDENCYLIST
GETCSXSCHEMA	MIGRATEALLXMLFROM9201	XMLSCHEMASTRIPUSERNAME
GETNAMESPACE	NUMTOHEX

CLEANSGAFORUPGRADE

Undocumented dbms_xdbutil_int.cleanSGAForUpgrade;

exec dbms_xdbutil_int.cleansgaforupgrade;

      

      PL/SQL procedure successfully completed.

CLEANUP_EXPIRED_NFSCLIENTS

Undocumented dbms_xdbutil_int.cleanup_expired_nfsClients;

exec dbms_xdbutil_int.cleanup_expired_nfsclients;

      

      PL/SQL procedure successfully completed.

CREATEACL

Create Access Control List dbms_xdbutil_int.createACL( acl_path IN VARCHAR2, objid IN RAW, data IN XMLTYPE) RETURN BOOLEAN;

TBD

CREATECROSSCONFOLDER

Undocumented dbms_xdbutil_int.createCrossConFolder( abspath IN VARCHAR2, vwname IN VARCHAR2) RETURN BOOLEAN;

TBD

CREATESYSTEMVIRTUALFOLDER

Undocumented dbms_xdbutil_int.createSystemVirtualFolder(abspath IN VARCHAR2) RETURN BOOLEAN;

-- from $ORACLE_HOME/rdbms/admin/catxdbst.sql and xdbu9202.sql

      

      Rem Create OID virtual folder

      Rem This step is repeatable.

      DECLARE

       ret BOOLEAN;

      BEGIN

        ret := dbms_xdbutil_int.createSystemVirtualFolder('/sys/oid');

        IF ret THEN

          dbms_xdb.setacl('/sys/oid', '/sys/acls/bootstrap_acl.xml');

        END IF;

      EXCEPTION

        WHEN OTHERS THEN

          ret := FALSE;

      END;

      /

      

      COMMIT;

      

      Rem Create ASM virtual folder

      Rem This step is repeatable.

      DECLARE

       ret BOOLEAN;

      BEGIN

        ret := dbms_xdbutil_int.createSystemVirtualFolder('/sys/asm');

        IF ret THEN

          dbms_xdb.setacl('/sys/asm', '/sys/acls/all_owner_acl.xml');

      END IF;

      EXCEPTION

        WHEN OTHERS THEN

          ret := FALSE;

      END;

      /

      

      COMMIT;

FIXACL

Undocumented dbms_xdbutil_int.fixACL(oldacl IN XMLTYPE) RETURN XMLTYPE;

TBD

FIXACL_DOWNGRADE

Undocumented dbms_xdbutil_int.fixACL_downGrade(oldacl IN XMLTYPE) RETURN XMLTYPE;

TBD

FLUSHSESSION

Flush the current session from memory dbms_xdbutil_int.flushSession;

exec dbms_xdbutil_int.flushSession;

      XDB FlushSession at Sun 16-May-2021 15:19:11

      

      PL/SQL procedure successfully completed.

GETCOMPILEDSCHEMA

Returns the schema XML based on the schema URL dbms_xdbutil_int.getCompiledSchema(schemaURL IN VARCHAR2) RETURN XMLTYPE;

SELECT dbms_xdbutil_int.getCompiledSchema('https://xmlns.oracle.com/xdb/acl.xsd')

      FROM dual;

      

      DBMS_XDBUTIL_INT.GETCOMPILEDSCHEMA('HTTPS://XMLNS.ORACLE.COM/XDB/ACL.XSD')

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

      <?xml version="1.0" encoding="US-ASCII"?>

      <schema xmlns="https://www.w3.org/2001/XMLSchema" xmlns:xdb="https://xmlns.oracle.com/xdb" xmlns:xdbacl="https://xmlns.oracle.com/xdb/acl.xsd" targetNamespace="https://xmlns.oracle.com/ xdb/acl.xsd" version="1.0" elementFormDefault="qualified" xdb:flags="1075863861" xdb:schemaURL="https://xmlns.oracle.com/xdb/acl.xsd" xdb:schemaOwner="XDB" xdb:numProps="46" xmlns:cs x="https://xmlns.oracle.com/2004/CSX">

        <annotation>

          <documentation>

            This XML schema describes the structure of XDB ACL documents.

      ...

        <element name="write-config" type="xdbacl:privilegeNameType"

          substitutionGroup="xdbacl:privilegeName" xdb:defaultTable=""

          xmlns:csx="https://xmlns.oracle.com/2004/CSX" csx:property

          ID="2037" xdb:global="true" xdb:memType="258" xdb:defaultTableSchema="XDB"/>

      </schema>

GETCOMPILEDSCHEMABYID

Returns the schema XML based on the schema object identifier dbms_xdbutil_int.getcompiledSchemaByID(schemaOID IN RAW) RETURN XMLTYPE;

TBD

GETCSXSCHEMA

Returns the schema XML based on the CSX schema dbms_xdbutil_int.getCSXSchema(schemaDoc IN XMLTYPE) RETURN XMLTYPE;

TBD

GETNAMESPACE

Get the resolved namespace for an attribute in the list (by position) dbms_xdbutil_int.getNameSpace( schemadoc IN XMLTYPE, inde IN BINARY_INTEGER) RETURN VARCHAR2;

conn xdb/xdb

      

      set long 1000000

      

      SELECT XMLTYPE(s.getclobval())

      FROM xdb$schema s;

      

      SELECT dbms_xdbutil_int.getNamespace(XMLTYPE(s.getclobval()), 1)

      FROM xdb$schemas;

GETNEWOID

Returns an object identifier dbms_xdbutil_int.getNewOID RETURN RAW;

SELECT dbms_xdbutil_int.getNewOID

      FROM dual;

      

      GETNEWOID

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

      C275128F141C4273E0531000000AFD2B

GET_TABLESPACE_TAB

Undocumented dbms_xdbutil_int.get_tablespace_tab( object_owner IN VARCHAR2, object_name IN VARCHAR2, object_subname IN VARCHAR2, object_type IN VARCHAR2) RETURN VARCHAR2;

TBD

IMPORTSEQUENCE

Undocumented dbms_xdbutil_int.importSequence( schema IN VARCHAR2, sequence IN VARCHAR2, value IN NUMBER);

TBD

INSTANCE_CALLOUT_IMP

Undocumented dbms_xdbutil_int.instance_callout_imp( obj_name IN VARCHAR2 obj_schema IN VARCHAR2 obj_type IN NUMBER prepost IN BINARY_INTEGER action OUT VARCHAR2 alt_name OUT VARCHAR2);

TBD

INSTANCE_EXPORT_ACTION

Undocumented dbms_xdbutil_int.instance_export_action( obj_name IN VARCHAR2 obj_schema IN VARCHAR2 obj_type IN NUMBER prepost IN BINARY_INTEGER action OUT VARCHAR2 alt_name OUT VARCHAR2

TBD

ISOBJECTGENERATED

Undocumented: Presumably returns 1 for a generated object, otherwise 0 dbms_xdbutil_int.isObjectGenerated( objname IN VARCHAR2, schname IN VARCHAR2) RETURN NUMBER;

SELECT dbms_xdbutil_int.isobjectgenerated('XDB', 'SYS_LOB0000042280C00022$$')

      FROM dual;

      

      DBMS_XDBUTIL_INT.ISOBJECTGENERATED('XDB','SYS_LOB0000042280C00022$$')

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

                                                                          0

ISTABLEOUTOFLINE

Undocumented: Presumably returns 1 for an out of line table, otherwise 0 dbms_xdbutil_int.isTableOutOfLine( tablename IN VARCHAR2, owner IN VARCHAR2) RETURN NUMBER;

SELECT dbms_xdbutil_int.isTableOutOfLine('XDB$PATH_INDEX_PARAMS', 'XDB')

      FROM dual;

      

      DBMS_XDBUTIL_INT.ISTABLEOUTOFLINE('XDB$PATH_INDEX_PARAMS','XDB')

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

                                                                     0

ISXMLNESTEDTABLE

Undocumented: Presumably returns 1 if a nested table, otherwise 0 dbms_xdbutil_int.isXMLNestedTable( tablename IN VARCHAR2, schname IN VARCHAR2) RETURN NUMBER;

SELECT dbms_xdbutil_int.isXMLNestedTable('XDB$SCHEMA', 'XDB')

      FROM dual;

      

      DBMS_XDBUTIL_INT.ISXMLNESTEDTABLE('XDB$SCHEMA','XDB')

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

                                                          0

LOOKUPSCHEMAOID

Undocumented dbms_xdbutil_int.lookupSchemaOID(schemaoid IN RAW) RETURN VARCHAR2;

TBD

LOOKUPSCHEMAURL

Undocumented dbms_xdbutil_int.lookupSchemaURL(schemaurl IN VARCHAR2) RETURN RAW;

TBD

MIGRATEALLXMLFROM9201

Undocumented dbms_xdbutil_int.migrateAllXMLFrom9201;

exec dbms_xdbutil_int.migrateAllXMLFrom9201;

NUMTOHEX

Converts a number to hex dbms_xdbutil_int.numToHex(n IN NUMBER) RETURN RAW;

SELECT dbms_xdbutil_int.numToHex(42)

      FROM dual;

      

      DBMS_XDBUTIL_INT.NUMTOHEX(42)

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

      2A

      

      SELECT dbms_xdbutil_int.numToHex(43)

      FROM dual;

      

      DBMS_XDBUTIL_INT.NUMTOHEX(43)

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

      2B

      

      SELECT dbms_xdbutil_int.numToHex(47)

      FROM dual;

      

      DBMS_XDBUTIL_INT.NUMTOHEX(47)

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

      2F

      

      SELECT dbms_xdbutil_int.numToHex(420128)

      FROM dual;

      

      DBMS_XDBUTIL_INT.NUMTOHEX(420128)

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

      066920

NUMTOHEX2

Converts a number to hex

Specifically what is different from this function, when compared to the above function, is not apparent. dbms_xdbutil_int.numToHex2(n IN NUMBER) RETURN RAW;

SELECT dbms_xdbutil_int.numToHex(420128)

      FROM dual;

      

      DBMS_XDBUTIL_INT.NUMTOHEX(420128)

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

      066920

PATCHREPOSITORYRESCONFIGLIST

Undocumented dbms_xdbutil_int.patchRepositoryResConfigList;

dbms_xdbutil_int.patchRepositoryResConfigList;

      BEGIN dbms_xdbutil_int.patchRepositoryResConfigList; END;

      *

      ERROR at line 1:

      ORA-06502: PL/SQL: numeric or value error

      ORA-06512: at "XDB.DBMS_XDBUTIL_INT", line 1051

      ORA-06512: at line 1

RAWTONUM

Converts RAW to NUMBER dbms_xdbutil_int.rawToNum(prefix_code IN RAW) RETURN NUMBER;

SELECT utl_raw.cast_to_raw('ABC')

      FROM dual;

      

      UTL_RAW.CAST_TO_RAW('ABC')

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

      414243

      

      SELECT dbms_xdbutil_int.rawToNum(utl_raw.cast_to_raw('ABC'))

      FROM dual;

      

      
      DBMS_XDBUTIL_INT.RAWTONUM(UTL_RAW.CAST_TO_RAW('ABC'))

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

                                                    4276803

      

      SELECT dbms_xdbutil_int.rawToNum('414243')

      FROM dual;

      

      DBMS_XDBUTIL_INT.RAWTONUM('414243')

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

                                  4276803

RAWTONUM2

Converts RAW to NUMBER dbms_xdbutil_int.rawToNum2(prefix_code IN RAW) RETURN NUMBER;

SELECT dbms_xdbutil_int.rawToNum2(utl_raw.cast_to_raw('ABC'))

      FROM dual;

      

      DBMS_XDBUTIL_INT.RAWTONUM2(UTL_RAW.CAST_TO_RAW('ABC'))

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

                                                     4276803

SETLINKPARENTS

Undocumented dbms_xdbutil_int.setLinkParents;

exec dbms_xdbutil_int.setLinkParents;

SETLINKPARENTSNEW

Undocumented dbms_xdbutil_int.setLinkParentsNew;

exec dbms_xdbutil_int.setLinkParentsNew;

      

      PL/SQL procedure successfully completed.

SYSTEM_INFO_EXP

Undocumented dbms_xdbutil_int.system_info_exp( prePost IN BINARY_INTEGER, connectString OUT VARCHAR2, version IN VARCHAR2, new_block OUT BINARY_INTEGER); RETURN VARCHAR2;

TBD

USESETLINKPARENTSNEW

Undocumented dbms_xdbutil_int.useSetLinkParentsNew RETURN BOOLEAN;

BEGIN

        IF dbms_xdbutil_int.useSetLinkParentsNew THEN

          dbms_output.put_line('Using ParentsNew');

        ELSE

          dbms_output.put_line('Not Using ParentsNew');

        END IF;

      END;

      /

      Not Using ParentsNew

      

      PL/SQL procedure successfully completed.

XMLSCHEMADEPENDENCYLEVEL

Undocumented dbms_xdbutil_int.xmlSchemaDependencyLevel( schoid IN RAW, owner IN VARCHAR2) RETURN BINARY_INTEGER;

TBD

XMLSCHEMAGETDEPENDENCYLIST

Undocumented dbms_xdbutil_int.XMLSchemaGetDependencyList( schoid IN RAW, owner IN VARCHAR2, depclob IN CLOB) RETURN BINARY_INTEGER;

TBD

XMLSCHEMASTRIPUSERNAME

Undocumented dbms_xdbutil_int.XMLSchemaStripUsername( schemadoc IN XMLTYPE, username IN VARCHAR2) RETURN CLOB;

conn xdb/xdb

      

      set long 1000000

      set pagesize 0

      set linesize 131

      col xml_out format a130

      col xml_len format 999999

      

      SELECT XMLTYPE(s.getclobval()) as xml_out

      FROM xdb$schema s

      WHERE rownum = 1;

      

      SELECT MIN(rowid) FROM xdb$schema;

      

      SELECT XMLTYPE(s.getclobval()) as xml_out

      FROM xdb$schema s

      WHERE rowid = 'AAANXLAACAAADecAAA';

      

      SELECT LENGTH(XMLTYPE(s.getclobval())) as xml_len

      FROM xdb$schema s

      WHERE rowid = 'AAANXLAACAAADecAAA';

      

      SELECT xdb.dbms_xdbutil_int.XMLSchemaStripUsername(XMLTYPE(s.getClobVal()), 'XDB') xml_out

      FROM xdb$schema s

      WHERE rowid = 'AAANXLAACAAADecAAA';

      

      col xml_out format 999999

      

      SELECT LENGTH(xdb.dbms_xdbutil_int.XMLSchemaStripUsername(XMLTYPE(s.getClobVal()), 'XDB')) xml_len

      FROM xdb$schema s

      WHERE rowid = 'AAANXLAACAAADecAAA';