Hi,

> create procedure TEST
> start transaction
> .... code o the procedure
> commit transaction

Can't do that (up to FB 2.1)

> I want that the table is updated only
> at the end of the procedure .

Call commit at the end of procedure execution at your client (app) code.

[client code]
StartATransaction;
ExecuteTheProcedure;
Commit;


Regards,
Anderson