Re: Row Locks?

Sunday Driver wrote:

> Hi
>
> If 2 users try to update the same row at the same time, the one that
> gets there first gets to save and the other gets an error about the
> row having been modified by another user, right?
>
> My (other) question is:
> Has anyone ever heard of Oracle leaving some kind of permanent lock on
> the row so that all users after that get the error msg about the row
> having been modified by another user?
>
> If not, why would all future users get the error when they try to
> modify these rows?
> TIA
> Bryn
> "In such cases as these,
> a good memory is unpardonable."

In answer to your first question ... yes.

In answer to your second ... issue a commit. If one has been issued you have an error condition and need to track it down.

Daniel A. Morgan Received on Wed Jun 06 2001 - 08:15:42 CEST