Starting transactions in Stored Procedures and User Defined Functions

Abstract: Starting transactions in Stored Procedures and User Defined Functions

    Question:

How do I start a transaction from within a user defined function, or stored procedure?

    Answer:

You cannot. Stored procedures and user defined functions already run within a transaction. InterBase does not support nested transactions, so it is not possible to start a transaction from within another transaction. This means you cannot start a transaction from within an stored procedure or user defined function.