Hi,
I am working with WinForm with .net 4.0. database is Oracle 11.2g. I am trying to implement the transaction using ODP.net. as per my learning i can use the CommitableTransaction for management the transaction. I have a screen where multiple Stored procedures
are used and called on various events. which insert / update / delete records and finally when user clicks data should be either committed or roll back (depends on validation). for this I am trying to use CommitableTransaction to maintain the connection object
at various events. On each event i am closing the connection object. So while doing this every time i am getting error "promote method returned invalid value for distributted transaction"
Other information
- windows 3 layered(present, BL & DL) desktop application
- ODP.net version 2.0
- .net framework 4.0
Please help me to resolve this or suggest the any other way to implement this
thanks in advance!!!