Starting transactions in Stored Procedures and User Defined Functions

By: Ben Matterson

Abstract: A brief explanation why you cannot start 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.

Server Response from: ETNASC04