The XA interface of PL allows a PL application to define a global transaction branch ID or XID and associate or dissociate the current session with the transaction branch. An XID is defined as a PL object type.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
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 DBMS_XA_XID attributes supported by the current OceanBase Database version.
| Attribute | Description |
|---|---|
| formatid | The ID of the format. It identifies different transaction managers (TM). |
| gtrid | The global transaction ID that uniquely identifies a global transaction. The maximum size is 64 bytes. |
| bqual | The qualifier of the branch. The maximum size is 64 bytes. |
