The XA_SETTIMEOUT function sets the transaction timeout in seconds for the current session.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_XA.XA_SETTIMEOUT (
seconds IN PLS_INTEGER)
RETURN PLS_INTEGER;
Parameters
| Parameter | Description |
|---|---|
| seconds | The timeout value specifies the maximum amount of time in seconds for which a transaction branch may be dissociated from the session before the system automatically terminates the transaction. The default timeout value is 60 seconds. |
Return values
For more information, see Possible constant return values for DBMS_XA.
The possible return values are XA_OK, XAER_RMERR, XAER_RMFAIL, and XAER_INVAL.
Considerations
Only the return value XA_OK indicates that the timeout value is set.