cmorris1441 (4/20/2013)
Dird (4/20/2013)
Yeah I just tested it in my env 😮Also the commit shouldn't be within the transaction but I guess you copied it before I added it in~
Dird
Should I add the commit to the trigger is it not necessary?
I believe when the trigger ends it automatically commits. When I included a commit it threw an error message on my environment. I just included it from force of habit from Oracle; seems it isn't needed. You could always make an update then disconnect your session & see if the update is still there when you connect to your DB again~
Dird