title: TransactionScope and Stored Procedure?
body: <p>I have two PL/SQL Stored procedure each handling its own Transaction (Begin/Commit and Rollback in case of error). From .Net code I Call these two SP as shown below.</p>
  
  <pre><code>   using (TransactionScope ts = new TransactionScope())
       {
            CallSP1();
            CallSP2().
            ts.SetComplete();
       }
  </code></pre>
  
  <p>If my Call to SP2 fails will it roll back the changes made by CallSP1()? If it does not roll back then does that mean that its better to handle the Transaction from the .Net application instead of inside Stored Procedure?</p>