Oracle DBMS_CSX_INT
Version 18.3.0.1

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 Internal support package with subroutines for DBMS_CSX_ADMIN when transporting a tablespace containing binary XML data.
AUTHID CURRENT_USER
Dependencies
ALL_XML_SCHEMAS DBA_XML_SCHEMA_DEPENDENCY DBMS_XSLPROCESSOR
ALL_XML_SCHEMA_ATTRIBUTES DBA_XML_SCHEMA_IMPORTS KU$_EXP_XMLSCHEMA_VIEW
ALL_XML_SCHEMA_COMPLEX_TYPES DBA_XML_SCHEMA_INCLUDES KU$_JOBSTATUS1220
ALL_XML_SCHEMA_ELEMENTS DBMS_ASSERT KU$_STATUS
ALL_XML_SCHEMA_NAMESPACES DBMS_CSX_ADMIN KU$_TABLE_XMLSCHEMA_VIEW
ALL_XML_SCHEMA_SIMPLE_TYPES DBMS_DATAPUMP KU$_TTS_TYPES_VIEW
ALL_XML_SCHEMA_SUBSTGRP_HEAD DBMS_LOB KU$_XMLSCHEMA_TYPES_VIEW
ALL_XML_SCHEMA_SUBSTGRP_MBRS DBMS_STANDARD KU$_XMLSCHEMA_VIEW
DBA_XMLSCHEMA_LEVEL_VIEW DBMS_XDBUTIL_INT USER_XML_SCHEMAS
DBA_XMLSCHEMA_LEVEL_VIEW_DUP DBMS_XDB_LIB XDB$SCHEMA
DBA_XML_SCHEMAS DBMS_XMLDOM XMLTYPE
Documented No
First Available 11.1.0.6
Security Model Owned by XDB with EXECUTE granted to PUBLIC
Source $ORACLE_HOME/rdbms/admin/prvtxdb0.plb
Subprograms
 
CreateTokenTables
Undocumented dbms_csx_int.createTokenTables(guid IN RAW);
See GetNewTokenSetIDs Demo Below
 
genTTMapping (new 18c)
Undocumented dbms_csx_int.genTTMapping(
guid     IN RAW,
toksuf   IN VARCHAR2,
name     IN VARCHAR2,
schema   IN VARCHAR2,
qn       IN VARCHAR2,
nm       IN VARCHAR2,
pt       IN VARCHAR2,
seqowner IN VARCHAR2,
seqname  IN VARCHAR2,
seqstart IN NUMBER);
TBD
 
GetCompiledSchema
Undocumented dbms_csx_int.getCompiledSchema(schemaURL IN VARCHAR2)
RETURN XMLTYPE;
TBD
 
GetCompiledSchemaByID
Undocumented dbms_csx_int.getCompiledSchemaByID(schemaOID IN VARCHAR2)
RETURN XMLTYPE;
TBD
 
GetCSXSchema
Undocumented dbms_csx_int.getCSXSchema(schemaDoc IN XMLTYPE) RETURN XMLTYPE;
TBD
 
GetNewTokenSetIDs (new 18c)
Undocumented dbms_csx_int.GetNewTokenSetIDs(
ewguid   OUT RAW,
guidhash OUT VARCHAR2);
DECLARE
 ewg   RAW(64);
 ghash VARCHAR2(64);
BEGIN
  dbms_csx_int.GetNewTokenSetIDs(ewg, ghash);
  dbms_output.put_line(ewg);
  dbms_output.put_line(ghash);

  dbms_csx_int.createTokenTables(ewg);
END;
/
7916F4C3D20A43C093C66F9C0CE3809D
3P2SRC7KGA8F097HJFJG6E704U
 
GetVocabulary
Undocumented dbms_csx_int.getVocabulary(
vocaId   IN BINARY_INTEGER,
vocabType IN BINARY_INTEGER,
rGUID      IN RAW)
RETURN XMLTYPE;
TBD
 
GetVocabularyFromToken
Undocumented dbms_csx_int.getVocabularyFromToken(
token     IN VARCHAR2,
isAttr    IN BINARY_INTEGER,
nmSpcID   IN BINARY_INTEGER,
tokenType IN BINARY_INTEGER,
rGUID     IN RAW)
RETURN XMLTYPE;
TBD
 
GetVocabularyFromTokenNoTxn
Undocumented dbms_csx_int.getVocabularyFromTokenNoTxn(
isGen     OUT BINARY_INTEGER,
token     IN  VARCHAR2,
isAttr    IN  BINARY_INTEGER,
nmSpcID   IN  BINARY_INTEGER,
tokenType IN  BINARY_INTEGER,
rGUID     IN  RAW,
toCreate  IN  BINARY_INTEGER)
RETURN XMLTYPE;
TBD
 
GetVocabularyNoTxn
Undocumented dbms_csx_int.getVocabularyNoTxn(
vocabID   IN BINARY_INTEGER,
vocabType IN BINARY_INTEGER,
rGUID     IN RAW)
RETURN XMLTYPE;
TBD
 
GuidFrom32
Undocumented dbms_csx_int.guidFrom32(guid32 IN VARCHAR2) RETURN VARCHAR2;
SELECT dbms_csx_int.guidFrom32('Morgan')
FROM dual;
 
GuidTo32
Undocumented dbms_csx_int.guidTo32(guidhex IN VARCHAR2) RETURN VARCHAR2;
SELECT dbms_csx_int.guidTo32(SYS_GUID())
FROM dual;
 
ImportMergeTokenTables
Undocumented dbms_csx_int.importMergeTokenTables;
exec dbms_csx_importMergeTokenTables;
 
LockTokenManager
Undocumented dbms_csx_int.lockTokenManager(rGUID IN RAW);
TBD
 
MergeImportedTokens
Undocumented dbms_csx_int.mergeImportedTokens;
exec dbms_csx_int.mergeImportedTokens;
 
PopulateKDSOFromGUID
Undocumented dbms_csx_int.populateKDSOFromGUID(guid IN RAW, toksuf IN VARCHAR2);
TBD
 
PopulateTokenTableSet
Undocumented dbms_csx_int.PopulateTokenTableSet(data IN XMLTYPE, eguid IN RAW);
TBD
 
Reencode_Binary_to_Central (new 18c)
Undocumented dbms_csx_int.Reencode_Binary_to_Central(callmode IN NUMBER);
TBD
 
RegisterToken
Undocumented

Overload 1
dbms_csx_int.registerToken(
tab     IN VARCHAR2,
nmSpcId IN NUMBER,
local   IN VARCHAR2,
flags   IN NUMBER,
id      IN NUMBER);
TBD
Overload 2 dbms_csx_int.RegisterToken(
tab      IN VARCHAR2,
nmSpcUri IN VARCHAR2,
id       IN NUMBER);
TBD
 
ToValidate
Undocumented dbms_csx_int.toValidate(test IN VARCHAR2)
RETURN BINARY_INTEGER;
SELECT dbms_csx_int.ToValidate('Morgan')
FROM dual;
 
TTMappingGenerator (new 18c)
Undocumented dbms_csx_int.TTMappingGenerator(
guid     IN RAW,
tokSuf   IN VARCHAR2,
name     IN VARCHAR2,
schema   IN VARCHAR2,
qn       IN VARCHAR2,
nm       IN VARCHAR2,
pt       IN VARCHAR2,
seqOwner IN VARCHAR2,
seqName  IN VARCHAR2,
seqStart IN NUMBER);
TBD
 
UpdateMasterTable
Undocumented dbms_csx_admin.updateMasterTable(
name   IN VARCHAR2,
schema IN VARCHAR2,
level  IN NUMBER,
guid   IN RAW,
tokSuf IN VARCHAR2);
TBD

Related Topics
Built-in Functions
Built-in Packages
DataPump Executable
DBMS_CSX_ADMIN
DBMS_CSX_INT2
DBMS_DATAPUMP
DBMS_EXTENDED_TTS_CHECKS
DBMS_PLUGTS
DBMS_PLUGTSP
DBMS_TDB
DBMS_TTS
What's New In 18cR3
What's New In 19cR3

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