Home » SQL & PL/SQL » SQL & PL/SQL » testing rollback (12.1.0.1)
testing rollback [message #661956] Fri, 07 April 2017 09:00 Go to next message
jinga
Messages: 116
Registered: January 2003
Senior Member
I have a stored procedure which is inserting into three different tables. I am testing to see if the rollback happens properly. I tried to exclusively lock the third table and executed the stored procedure. It was kept on running until I deliberately killed the session in which I had locked the third table. Could any one help me to other ways to test rollback?

Re: testing rollback [message #661958 is a reply to message #661956] Fri, 07 April 2017 09:09 Go to previous messageGo to next message
cookiemonster
Messages: 13291
Registered: September 2008
Location: Rainy Manchester
Senior Member
Well that doesn't test rollback, that tests locking.
Run the procedure, rollback, check data hasn't been inserted. Why would you need to do anything else?
Re: testing rollback [message #662003 is a reply to message #661958] Tue, 11 April 2017 12:56 Go to previous message
Bill B
Messages: 1802
Registered: December 2004
Senior Member
Do you actually think that if their was a problem with rollback in oracle that the yelling from customers would be heard across the entire world.
Previous Topic: Hierarchical Queries
Next Topic: cursors
Goto Forum:
  


Current Time: Sat Oct 20 23:51:54 CDT 2018