> ... should I be using commit before end ... Commit and end are synonyms; you don't need both.
> ... this is single user, I assume using immediate or exclusive is ok ... It's OK but not necessary. A simple begin is just as good, since no one else can apply a lock before yours is upgraded. Regards