James wrote:

>>If COMMIT is called and returns an exception, the transaction isn't

> Thank you Helen. Iam sorry I didn't mention clearly that what I mean by
> exception raise is the exceptions I create in my Database. So under such
> kind of exception does the transaction finish or not? If yes then I
> don't have to do anything right? and If No either I rollback or try to
> fix the problem.

If your exception is not from the COMMIT, what is it from?
If you have 'succeeded' in doing something that would require a commit,
but decide not to proceed, then the same rules apply, and you must ROLLBACK.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services