community.borland.com

Article #29888: 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.

Last Modified: 07-APR-03