Home » Developer & Programmer » Forms » LOCK
LOCK [message #683232] Thu, 17 December 2020 11:04 Go to next message
GHDSSS
Messages: 13
Registered: April 2020
Junior Member
Hello Team,

I have Issue in the Form occasionally when End User clicking button ('when Button Pressed Trigger' Preform Update Statement ) The Oracle Application screen Just spin and hanging (locked)


Please help me to understand the Issue and get the Solutions

Thanks
Sandeep Ganta

[Updated on: Thu, 17 December 2020 11:08]

Report message to a moderator

Re: LOCK [message #683234 is a reply to message #683232] Fri, 18 December 2020 00:16 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It looks as if UPDATE (which is initiated by the trigger) is trying to update a row which is being held by someone else - maybe another user, working on the same data set. Such a lock is released when the update operation is either committed or rolled back. I suppose that you should, actually, COMMIT.

Try to add it (the COMMIT) to the end of the trigger and see what happens. Otherwise, contact the DBA and ask them to see what's going on in the database, i.e. to check locks (especially on the table which is being updated).
Previous Topic: Search Form like LOV
Next Topic: sms
Goto Forum:
  


Current Time: Thu Mar 28 10:52:56 CDT 2024