--- In firebird-support@yahoogroups.com, "johnsparrowuk"
<jsparrow@e...> wrote:

> > > begin
> > > insert into mytable values ('a');
> > > execute procedure xx; /* xx throws exception, insert is undone
> */
> > > when any do
> > > begin
> > > ...
> > > end
> > > end!!

Note if procedure XX contains SUSPEND, changes made within this
procedure before SUSPEND will not be undone and can be undone only
from client side. Sunce SUSPEND is'nt recommended for executable
procedures, you are safe from this nuance while you follow
recommendation. But if you make something like

begin
For Select Form procedure XX ...;
when any do
begin
...
end
end!!

and procedure XX makes data modificiations, be cautious.

Best regards,
Alexander.