1  –  on-or-off-value

    Specifies a string literal or host variable containing the
    keyword ON or OFF.

    The 'ON' argument specifies that if a COMMIT or ROLLBACK
    statement is executed when there is no active transaction, then
    SQL will not raise an error. The 'OFF' argument specifies that
    if a COMMIT or ROLLBACK statement is executed when there is
    no active transaction, then SQL will raise an error. You can
    specify the 'ON' and 'OFF' arguments using any case (uppercase,
    lowercase, or mixed case).

    By default, if there is no active transaction, SQL raises an
    error when the COMMIT or ROLLBACK statement is executed. This
    default is retained for backward compatibility for applications
    that want to detect this situation.