Home » Developer & Programmer » Forms » FRM-40654 Error
- FRM-40654 Error [message #85933] Thu, 12 August 2004 20:22 Go to next message
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.

�

Report message to a moderator

- Re: FRM-40654 Error [message #85944 is a reply to message #85933] Sun, 15 August 2004 20:04 Go to previous message
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.

Report message to a moderator

Previous Topic: using forms_ddl to insert
Next Topic: i need help in developing application in Oracle 9i DS
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Mar 04 17:02:23 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.