XA_COMMIT

The XA_COMMIT function is used to commit a global transaction specified by xid.

Syntax

DBMS_XA.XA_COMMIT (
    xid       IN  DBMS_XA_XID,
    onePhase  IN  BOOLEAN)
RETURN PLS_INTEGER;

Parameters

Return values

For more information, see Possible constant return values of DBMS_XA.

The possible error codes are: XAER_RMERR, XAER_RMFAIL, XAER_NOTA, XAER_INVAL, or XAER_PROTO. Other possible return values include: XA_OK, XA_RB *, XA_HEURHAZ, XA_HEURCOM, XA_HEURRB, and XA_HEURMIX.

Considerations

• Applications must call the XA_COMMIT function to commit a global transaction specified by xid. They cannot call the COMMIT function.

• If the onePhase value is TRUE, the resource manager must use a one-phase commit protocol to commit the work specified by xid. Otherwise, the XA_COMMIT function can be called only after all branches of the global transaction have been successfully completed and the previous XA_PREPARE call returned XA_OK.

• Applications must make separate XA_COMMIT calls for each transaction branch of a global transaction that returned XA_OK from the XA_PREPARE function.

• If the resource manager did not commit the transaction and the onePhase parameter is set to TRUE, the resource manager can return one of the XA_RB * codes. After returning, the resource manager rolls back the work of the branch and releases all reserved resources.