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 is now availble. If you haven't you downloaded already: Why?

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