Because I want the first update to succeed regardless of what happens in
steps b and c. Not being able to do commits in procedures is a serious
missing feature. I use procedures in Oracle to massage data all the time,
and do it on millions of record. So I will commit the changes every 500
records. Hopefully this will make it into v2.0.

Alexander V.Nevsky wrote:

>--- 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.
>
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://sourceforge.net/projects/dbexpressplus