XA_COMMIT

The XA_COMMIT function commits the global transaction specified in the xid parameter.

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 for DBMS_XA.

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

Considerations

• Applications cannot call COMMIT. They must call XA_COMMIT to commit the global transaction specified by xid. You must be granted the FORCE ANY TRANSACTION privilege before you can commit a transaction branch created by another user.

• If onePhase is set to TRUE, the resource manager (RM) uses a one-phase commit protocol to commit work done on behalf of xid. Otherwise, XA_COMMIT can only be called after all branches of the global transaction are prepared and the previous call to XA_PREPARE returns XA_OK.

• An application must call XA_COMMIT separately for each transaction branch of the global branch for which XA_PREPARE returns XA_OK.

• If the RM did not commit the transaction and onePhase is set to TRUE, the RM may return one of the XA_RB* codes. At this point, the RM has rolled back the branch's work and has released all resources held.