Oracle | DBMS_CSX

Oracle DBMS_CSX_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 support package for DBMS_CSX_ADMIN when transporting tablespaces containing binary XML data.

GetCSXSchema is relocatedto DBMS_XDBUTIL_INT as of 19c

AUTHID CURRENT_USER

Data Types TYPE tokenids ....

Dependencies

ALL_OBJECTS	DBMS_STANDARD	KU$_STATUS
DBMS_ASSERT	DBMS_XDB_LIB	TOKENIDS
DBMS_CSX_ADMIN	DBMS_XSLPROCESSOR	TOKENS
DBMS_DATAPUMP	KU$_JOBSTATUS1220	XMLTYPE

Documented No

First Available 11.1

Security Model Owned by XDB with EXECUTE granted to PUBLIC

Source $ORACLE_HOME/rdbms/admin/prvtxdb0.plb

Subprograms

CreateTokenTables	GetNewTokenSetIDs	MergeImportedTokens
decodeInvalidTokens	GetVocabulary	PopulateKDSOFromGUID
fixInvalidQnameIDs	GetVocabularyFromToken	PopulateTokenTableSet
genTTMapping	GetVocabularyFromTokenNoTxn	Reencode_Binary_to_Central
getAllTokens	GetVocabularyNoTxn	RegisterToken
GetCompiledSchema	GUIDFrom32	ToValidate
GetCompiledSchemaByID	GUIDTo32	TTMappingGenerator
getInvalidNamespaceIDs	ImportMergeTokenTables	UpdateMasterTable
getInvalidQNameIDs	LockTokenManager

CreateTokenTables

Undocumented dbms_csx_int.createTokenTables(guid IN RAW);

See GetNewTokenSetIDs Demo Below

decodeInvalidTokens

Undocumented dbms_csx_int.decodeInvalidTokens(csx IN BLOB) RETURN CLOB;

TBD

fixInvalidQnameIDs

Undocumented dbms_csx_int.fixInvalidTokens(csx IN BLOB) RETURN BLOB;

TBD

genTTMapping

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

getInvalidNamespaceIDs

Undocumented dbms_csx_int.getInvalidNamespaceIDs(csx IN BLOB) RETURN dbms_csx_int.tokenids;

TBD

getInvalidQNameIDs

Undocumented dbms_csx_int.getInvalidQNameIDs(csx IN BLOB) RETURN dbms_csx_int.tokenids;

TDB

GetCSXSchema

Undocumented dbms_csx_int.getCSXSchema(schemaDoc IN XMLTYPE) RETURN XMLTYPE;

TBD

GetNewTokenSetIDs

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

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

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