Specifies the number of seconds for a given transaction to wait
    for other transactions to complete. This interval is only valid
    for the transaction specified in the SET TRANSACTION statement.
    Subsequent transactions return to the database default timeout
    interval. A timeout value of 0 specifies NOWAIT.

    When starting a transaction, there are three different values
    that are used to determine the lock timeout interval for that
    transaction. Those values are:

    1. The value specified in the SET TRANSACTION statement

    2. The value stored in the database as specified in CREATE or
       ALTER DATABASE

    3. The value of the logical name RDM$BIND_LOCK_TIMEOUT_INTERVAL

    The timeout interval for a transaction is the smaller of the
    value specified in the SET TRANSACTION statement and the value
    specified in CREATE DATABASE. However, if the logical name
    RDM$BIND_LOCK_TIMEOUT_INTERVAL is defined, the value of this
    logical name overrides the value specified in CREATE DATABASE.