FRM-40654 Error [message #85933] |
Thu, 12 August 2004 20:22 |
Mahesh
Messages: 90 Registered: January 2001
|
Member |
|
|
I have encountered the above error.
It gives error msg.
Record is locked by another user. Re-query to see the change.
Please help.
|
|
|
Re: FRM-40654 Error [message #85944 is a reply to message #85933] |
Sun, 15 August 2004 20:04 |
AB
Messages: 41 Registered: July 2002
|
Member |
|
|
Mahesh,
This happens when you try to update a record which is being updated by another user/instance at the same time. Before updating the record lock the record explicitly using FOR UPDATE OF...NO WAIT Sql statement.
When this Sql is executed and if it goes to Exception with error code -54 then the record is in use. You can handle this exception and display suitable message.
|
|
|