Sean,

> Ivan,
>
>> > A stored procedure call in Firebird is atomic.
>>
>> Actually not. Selectable stored procedure is atomic only between
> SUSPEND
>> calls, i.e. if an error occurs, the work is undone only to the point
> the
>> last SUSPEND was called.
>
> I think I know what you are trying to say but ... as written it is not
> correct.

I will try again.

If an error is raised inside selectable procedure, the work is undone
only to the last internal savepoint, which is set at the start of the SP,
and when SUSPEND is performed.

Ivan