The XA_SETTIMEOUT function sets the transaction timeout in seconds for the current session.
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.
Usage notes
Only the return value XA_OK indicates that the timeout value is set.