What happens to the base table transactions when procedure has some error?

Procedure A calls procedure B. A updates table t1, t2. B updates table t3. If some error happens to B what happens to the updates in all those tables? Whether they will rollback or commit? If commits how far it will commit?

Questions by plsqlgeek   answers by plsqlgeek

Showing Answers 1 - 1 of 1 Answers

vishal.bhadange

  • Aug 24th, 2013
 

CASE 1 (If you are not handling exception in Procedure B, none of the table gets updated)

Code
  1.  



CASE 2 (If you are handling exception in Procedure B, table t1 and t2 gets updated, But table t3 will not update)

Code
  1.  

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions