Subject Re: [firebird-support] how to use a transaction in SP
Author Helen Borrie
At 12:58 PM 1/07/2003 +0000, you wrote:
>Can anybody tell me, how to use a transaction in a SP.
>As, it is done in SQL server i.e. begin/commit/Rollback transaction

Firebird doesn't support embedded transactions (Firebird sysdba's like to
sleep at home!)

You can embed procedures inside other procedures, though, and return custom
exceptions to the caller procedure.

Coming in a future release (possibly 1.6) will be savepoints, another way
to condition whether a block of work inside a procedure will be carried
through or undone.