[All]
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.
Connect with Us