Re: Oracle Triggers / Locks

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 30 Jun 1999 10:00:59 +0100
Message-ID: <930733506.14356.0.nnrp-13.9e984b29@news.demon.co.uk>

You'd better bet that Thomas is correct.

Where in your data entry process do you issue a commit, you don't mention this in your original post ?

If you haven't then, despite the fact that you 'refreshed' the data, your client software probably has an image of what the record looked like following its update, and compares it with the current image. Since the two images do not match the client assumes that another session has changed the data in the interim.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Jonathon Marshall wrote in message <7lc7kn$htj$1_at_news.mch.sbs.de>...
>Hi there Thomas
>
>and thanks for your response.
>
>If you read my email you will note that I do refresh the data set
>and the record is still locked.
>
Received on Wed Jun 30 1999 - 04:00:59 CDT