locked
promote method returned invalid value (ODP.net ) RRS feed

  • Question

  • 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!!!

    Friday, April 25, 2014 3:25 PM

All replies

  • this is the Sync Framework forum, you might want to post your question to the appropriate forums.
    Tuesday, April 29, 2014 12:58 PM