Thanks Set,

I was wondering if there is a way to handle this exclusively in the DB
rather than by using explicit transactions which I assume have to be
called from the client application?

Mitch