Oracle | DBMS_CSX

Oracle DBMS_CSX_INT Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

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_UTILITY	KU$_STATUS
DBMS_ASSERT	DBMS_XDB_LIB	TOKENIDS
DBMS_CSX_ADMIN	DBMS_XSLPROCESSOR	TOKENS
DBMS_DATAPUMP	KU$_JOBSTATUS1220	XMLTYPE
DBMS_STANDARD

Documented No

First Available 11.1

Security Model Owned by XDB with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/prvtxdb0plb

Subprograms

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

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

FINDBINARYXMLANDREMAP (new 23ai)

Undocumented dbms_csx_int.findBinaryXMLandRemap(tablespace_name IN VARCHAR2);

TBD

FIXINVALIDQNAMEIDS

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

TBD

GETALLTOKENS

Undocumented dbms_csx_int.getAllTokens(csx IN BLOB) RETURN xdb.tokens;

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

GETINVALIDROWS (new 23ai)

Undocumented dbms_csx_int.getInvalidRows( owner IN VARCHAR2, table_name IN VARCHAR2, column_name IN VARCHAR2, owner_stg IN VARCHAR2, table_stg IN VARCHAR2, expresion IN VARCHAR2);

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');

GUIDTO32

Undocumented dbms_csx_int.guidTo32(guidhex IN VARCHAR2) RETURN VARCHAR2;

SELECT dbms_csx_int.guidTo32(SYS_GUID());

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

SPLITTOKENSANDNAMESPACES (new 23ai)

Undocumented dbms_csx_int.splitTokensAndNameSpaces;

exec dbms_csx_int.splitTokensAndNameSpaces;

      

      PL/SQL procedure successfully completed.

TOKENCOLLISIONENTRY (new 23ai)

Undocumented dbms_csx_int.TokenCollisionEntry( schema IN VARCHAR2, name IN VARCHAR2);

TBD

TOVALIDATE

Undocumented dbms_csx_int.toValidate(test IN VARCHAR2) RETURN BINARY_INTEGER;

SELECT dbms_csx_int.ToValidate('Morgan');

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