>I thought ALL changes were buffered and therefore were revertable at any time.

They are, if you use Table buffering and not Row Buffering. Row buffering is the only kind that commits changes without you asking, and is therefore IMO, _never_ a good idea.