| General Information |
| Source |
{ORACLE_HOME}/rdbms/admin/prvtxdb0.plb |
| Dependencies |
| ALL_POLICIES |
DBMS_SYS_SQL |
SYS |
| ALL_TRIGGERS |
DBMS_XDBZ0 |
XDB$PATCHUPSCHEMA |
| ALL_USERS |
DBMS_XDB_LIB |
XMLTYPE |
| DBMS_SQL |
SETMODFLG |
|
|
| Object Privileges |
execute on dbms_xdbutil_int is granted to public |
| |
| CREATESYSTEMVIRTUALFOLDER |
Undocumented |
dbms_xdbutil_int.createsystemvirtualfolder(abspath 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; |
| |
| GETNAMESPACE |
| Get the resolved namespace for an attribute in the list (by position) |
dbms_xdbutil_int.getnamespace(schemadoc
XMLTYPE, inde 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()),
0)
FROM xdb$schema s; |
| |
| ISOBJECTGENERATED |
| Undocumented:
Presumably returns 1 for a generated object, otherwise 0 |
dbms_xdbutil_int.isobjectgenerated(objname VARCHAR2, schname VARCHAR2)
RETURN NUMBER |
SELECT
dbms_xdbutil_int.isobjectgenerated('XDB', 'SYS_LOB0000042280C00022$$')
FROM dual; |
| |
| ISTABLEOUTOFLINE |
| Undocumented:
Presumably returns 1 for an out of line table, otherwise 0 |
dbms_xdbutil_int.istableoutofline(tablename VARCHAR2, owner VARCHAR2)
RETURN NUMBER |
SELECT
dbms_xdbutil_int.istableoutofline('XDB$PATH_INDEX_PARAMS', 'XDB')
FROM dual; |
| |
| ISXMLNESTEDTABLE |
| Undocumented:
Presumably returns 1 if a nested table, otherwise 0 |
dbms_xdbutil_int.isxmlnestedtable(tablename
VARCHAR2, schname VARCHAR2)
RETURN NUMBER |
SELECT
dbms_xdbutil_int.isxmlnestedtable('XDB$SCHEMA', 'XDB')
FROM dual; |
| |
| NUMTOHEX |
| Converts a number to
hex |
dbms_xdbutil_int.numtohex(NUMBER)
RETURN RAW |
SELECT dbms_xdbutil_int.numtohex(42)
FROM dual;
SELECT dbms_xdbutil_int.numtohex(43)
FROM dual;
SELECT dbms_xdbutil_int.numtohex(47)
FROM dual;
SELECT dbms_xdbutil_int.numtohex(48)
FROM dual; |
| |
| RAWTONUM |
| Converts RAW to
NUMBER |
dbms_xdbutil_int.rawtonum(prefix_code
RAW) RETURN NUMBER
|
SELECT utl_raw.cast_to_raw('ABC')
FROM dual;
SELECT dbms_xdbutil_int.rawtonum(utl_raw.cast_to_raw('ABC'))
FROM dual; |
| |
| SETPRINTMODE |
| Undocumented |
dbms_xdbutil_int.setprintmode(modeval
BINARY_INTEGER)
|
public static String SET_PRINT_MODE="begin
dbms_xdbutil_int.setPrintMode(:1); end;";
|
| |
| XMLSCHEMAGETDEPENDENCYLIST |
| Undocumented |
dbms_xdbutil_int.xmlschemagetdependencylist(
schoid RAW, owner VARCHAR2, depclob CLOB) RETURN BINARY_INTEGER
|
| TBD |
| |
| XMLSCHEMASTRIPUSERNAME |
| Undocumented |
dbms_xdbutil_int.xmlschemastripusername(
schemadoc XMLTYPE, username 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;
SELECT LENGTH(XMLTYPE(s.getclobval())) as xml_len
FROM xdb$schema s;
SELECT xdb.dbms_xdbutil_int.XMLSchemaStripUsername(XMLTYPE(s.getClobVal()),
'XDB') xml_out
FROM xdb$schema s;
col xml_out format 999999
SELECT LENGTH(
xdb.dbms_xdbutil_int.XMLSchemaStripUsername(XMLTYPE(s.getClobVal()),
'XDB')) xml_len
FROM xdb$schema s; |