| testing rollback [message #661956] |
Fri, 07 April 2017 09:00  |
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  |
cookiemonster
Messages: 13920
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 |
Bill B
Messages: 1971
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
