ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

C# TransactionOption.RequiresNew ORA-24761 Transaction Rolled Back

633815Apr 14 2008 — edited Apr 16 2008

Hi all,
I am working on Web service in C# with VS 2005. I am using IIS 5.1, Oracle 10g.
Problem:
I used
[WebMethod(TransactionOption = TransactionOption.RequireNew)]
[AutoComplete]
with each Web Method of web service. If something goes wrong inside the web method i use ContextUtil.SetAbort() to abort the transaction else ContextUtil.SetComplete()
Now after getting some problem while executing a web method, next time when i call any web method oracle terminates the transaction passing error "ORA-24761 : Transaction rolled back". But if again, i try the same call, its got executed with no problem!
Any kind of help, will be appreciated, its urgent.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 14 2008

Added on Apr 14 2008

#odp-net

1 comment

2,743 views