in reply to Class::DBI question
Funnily enough I had this same problem yesterday.
The update will change the values - but you want the commit to happen after you change them not before.
I assumed that an implicit commit was part of the update but it isn't with Oracle