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: 19350
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".
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
Previous Topic: oracle forms basic info required
Next Topic: item property copy value from item
Goto Forum:
  


Current Time: Sat Aug 02 03:00:23 CDT 2014

Total time taken to generate the page: 0.05560 seconds