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-compatible 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.