The XA interface of PL/SQL allows PL/SQL applications to define global transaction branch IDs (XIDs) and associate or dissociate the current session with a transaction branch. XIDs are defined as PL/SQL object types.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
TYPE DBMS_XA_XID IS OBJECT(
formatid NUMBER,
gtrid RAW(64),
bqual RAW(64),
constructor function DBMS_XA_XID(
gtrid IN NUMBER)
RETURN SELF AS RESULT,
constructor function DBMS_XA_XID (
gtrid IN RAW,
bqual IN RAW)
RETURN SELF AS RESULT,
constructor function DBMS_XA_XID(
formatid IN NUMBER,
gtrid IN RAW,
bqual IN RAW DEFAULT HEXTORAW('00000000000000000000000000000001'))
RETURN SELF AS RESULT)
The following table describes the attributes of the DBMS_XA_XID object type in the current version of OceanBase Database.
| Attribute | Description |
|---|---|
| formatid | The format identifier, a numeric value used to identify different transaction managers (TM). |
| gtrid | The global transaction identifier, a unique identifier for a global transaction, with a maximum length of 64 bytes. |
| bqual | The branch qualifier, with a maximum length of 64 bytes. |