| Subject | Re: [firebird-support] how to use a transaction in SP |
|---|---|
| Author | Helen Borrie |
| Post date | 2003-07-01T13:26:47Z |
At 12:58 PM 1/07/2003 +0000, you wrote:
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.
heLen
>Hi,Firebird doesn't support embedded transactions (Firebird sysdba's like to
>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
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.
heLen