The XA_ROLLBACK function instructs the resource manager (RM) to roll back a transaction branch.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_XA.XA_ROLLBACK (
xid IN DBMS_XA_XID)
RETURN PLS_INTEGER;
Parameters
| Parameter | Description |
|---|---|
| xid | For more information, see DBMS_XA_XID object type. |
Return values
For more information, see Possible constant return values for DBMS_XA.
The possible return values are XA_OK, XA_RB*, XA_HEURHAZ, XA_HEURCOM, XA_HEURRB, and XA_HEURMIX.
Considerations
You must be granted the FORCE ANY TRANSACTION privilege before you can roll back a transaction branch created by another user.