Hi all, my questions are:

What happen if something go wrong in a store procedure with this body?
If an error occur in point A or B. The rest of procedure is executed however?
It's correct after any INSERT, UPDATE, DELET use row_count? Or how can make atomic the body of store procedure

begin
...
number = gen_id(gen_number_id, 1);

/* point A */

insert into acquisti_riga (.....) values ( number......);

update ... set ... = ... + 1 where .... = .... and ... = ....;

/* point B */

execute procedure mov_ins(....);
....
end

Note: ver Firebird 1.5
Thanks in advance
Alberto

[Non-text portions of this message have been removed]