locked
Oracle transaction not working properly RRS feed

  • Question

  • User-1934530859 posted

    My web app is kicking off a set of oracle calls like so. I am testing a set of calls that intentionally creates an error to test the transactional capabilities. One set of records worked and rolledback the other set did not and created orphaned records. What am I doing wrong and what do I need to look at?

    using (TransactionScope transScope = new TransactionScope()) //BEGIN TransScope
    {
      
            OracleDBMethod1(parm1);
            OracleDBMethod2(parm2);
            OracleDBMethod3(parm3);
    	transScope.Complete();
    				
    }//End TransScope
    Friday, October 14, 2011 7:59 AM

Answers

All replies