Subject Re: Procedure Help
Author Alexander V.Nevsky
--- In, Thomas Miller <tmiller@b...>
> 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.