Home » Developer & Programmer » Forms » Form record locking
Form record locking [message #594042] Thu, 22 August 2013 22:36 Go to next message
newbieinapps
Messages: 13
Registered: August 2013
Junior Member
Hi,
I am newbie to the forum an Oracle also.

I am using Forms 6i
and developed a Master Detail Oracle Form for Oracle EBS 11i application.

I was asked to write a pl/sql program so that..
When a user updating an existing record at the same time another user query the same record and try to update the same time, the record should be locked and a message should popup saying the record is being updated by another user.

How would I achieve this.

Thanks

[Updated on: Thu, 22 August 2013 22:37]

Report message to a moderator

Re: Form record locking [message #594077 is a reply to message #594042] Fri, 23 August 2013 04:40 Go to previous messageGo to next message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Forms does it itself, you don't have to program it. You'll get "FRM-40654: Record has been updated by another user. Re-query to see change".

Report message to a moderator

Re: Form record locking [message #594341 is a reply to message #594042] Tue, 27 August 2013 10:38 Go to previous message
newbieinapps
Messages: 13
Registered: August 2013
Junior Member
Thanks for the information

Report message to a moderator

Previous Topic: oracle forms basic info required
Next Topic: item property copy value from item
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 18:17:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.