Re: Problem with Multiple transaction ROLLBACK

From: Ed Prochak <edprochak_at_interfacefamily.com>
Date: Mon, 31 May 1999 13:47:45 -0400
Message-ID: <3752CB41.3F2C850E@interfacefamily.com>

Are you sure the procedures don't have do COMMIT? Hidden COMMITs ca be a real pain.

nick wrote:
>
> BEGIN
> SELECT ....;
> UPDATE ...;
> sp_ins (...); /* suposed this procedure raise an error.
> Rollback works well */
> .
> .
> sp_upd (...); /* But when this procedure raise an error*/
> sp_del (...); /* before this call already commit WHY? */
> .
> INSERT ...;
> EXCEPTION
> WHEN OTHERS THEN
> ROLLBACK;
> RAISE;
> COMMIT;
> END;
>
> Thanks in advance,
> Nick.

--
Ed Prochak
Magic Interface, Ltd.
440-498-3702 Received on Mon May 31 1999 - 12:47:45 CDT