On Fri, 12 Oct 2001, J C Lawrence wrote:
>
> Does an error during a transaction invalidate the transaction?
>
> eg
>
> BEGIN
> SomeQueryThatSucceeds
> SomeQueryThatFails
> SomeOtherQueryThatSucceeds
> COMMIT
>
> Will the transaction successfully COMMIT, or will the COMMIT fail?
>
> Translation: Do I need to monitor for error conditions during a
> transaction and manually do the ROLLBACK in those cases?
The transaction will be forced to roll back.