--- In firebird-support@yahoogroups.com, Thomas Miller <tmiller@b...>
wrote:

> Can I use COMMIT in a stored procedure? I want to do several
> things in the stored procedure
>
> a) update a column
> commit;
> b) process a select statement
> Set return values if found
> c) Update a column
> commit;
>

Thomas, what is the reason for this commits? Possible exceptions, I
suppose? Take a look at exception handling within SP (WHEN ... DO in
chapter Procedures and Triggers in Language Reference).

Best regards, Alexander.