Other day I was working on my forms application and I found some strange error “Record is update by another User, re query or clear to see…”

Usually when we two Users are trying to update same and no one has committed because of Oracle Lock above error is thrown to the forms application

But here in this case I was the only user to update this record.

After some investigation I found this error is genuine for my case as well but I could not find the concrete solution for that

Residing in one form (Contains database block) I pressed one button that was doing some calculation and inserting /updating into some tables

After process done I tried to update some field’s value on the current form and tried to save this record

System throws this error “Record is update by another User, re query or clear to see…”

The reason was, the moment I pressed process button on my form, this process updates the status field of the same record where I am currently

Residing in, but this record was not refreshed from the database and the moment as I told before I update some field from form and tried to save the record

It got locked and throws this error.

First try to reproduce this error and give me some solution to resolve this

I tried with the setting property (block property) DML Returning value to “YES” but didn’t work.

Dushyant Nayak