Hi

Refer to my issues http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=19249

It was told that problem was with MS and it had fixed this issue

You have to install a specific update (hotfix) too. Please check this KB article: http://support.microsoft.com/kb/959209/

Walaa wrote:

You have to install a specific update (hotfix) too. Please check this KB article: http://support.microsoft.com/kb/959209/

Well found out what is causing the issue. It is default behaviour of oracle !

I was updating like " UPDATE MONTHLYBILL SET BALANCEAMOUNT=0 WHERE MONTHLYBILL_ID=0"

Actually MONTHLYBILL_ID=0 does not exist. and hence zero rows are updated and thus transaction commits !

So in my case, it works fine .NET 2.0 without any patch update