It should work with "refresh on commit". But it doesn't work in every situation (like across dblinks). Read in manuals about restrictions.