The XA_SETTIMEOUT function is used to set the transaction timeout interval (in seconds) for the current session.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
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) that a transaction branch can be disassociated from the session before the system automatically aborts the transaction. The default value is 60 seconds. |
Return value
See Possible constant return values of DBMS_XA.
The function may return the following values: XA_OK, XAER_RMERR, XAER_RMFAIL, or XAER_INVAL.
Considerations
The timeout value is considered to be set only when the return value is XA_OK.