LOCK [message #683232] |
Thu, 17 December 2020 11:04 |
|
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 |
|
Littlefoot
Messages: 21818 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).
|
|
|