You can use the DECLARE TRANSACTION statement:

    o  In interactive SQL

    o  Embedded in host language programs to be precompiled

    o  In a context file

    o  As part of the DECLARE section in an SQL module

    o  As part of the module header in a CREATE MODULE statement

    o  In dynamic SQL as a statement to be dynamically executed

    In host language programs, you can have only a single DECLARE
    TRANSACTION statement in each separately compiled source file.
    See the Oracle Rdb SQL Reference Manual for more information.

    The DECLARE TRANSACTION statement is an extension to standard
    SQL syntax. If your program must adhere to standard SQL syntax,
    you can isolate a DECLARE TRANSACTION statement by putting it in
    a context file. For more information on context files, see the
    Oracle Rdb Guide to SQL Programming.