Locking problem?
From: Robert Garcia <scruloos_at_gte.net>
Date: Tue, 23 Nov 1999 17:31:39 GMT
Message-ID: <383ACFB6.D73EDAF8_at_gte.net>
[Quoted] [Quoted] I have a Developer 2000, Windows NT, Oracle Server version 7, application that I execute update procedures out of a Validation Trigger. The problem is that the update procedure hangs - instead of executing an On Error Trigger - when one of the records to be updated is being edited in another instance of my application. A further description is as follows:
When running two instances of my application, the first instance was locked onto (editing) a record that I knew that the second instance was going to update. When following the breakpoints of the second instance, it got to the update procedure (called out of the validation trigger) and the screen froze. I have 'on error' triggers set on the item that triggered the update procedure, on the block of this item. The 'on error' trigger will display an alert which will require a response from the user. None of these alerts was executed.
Date: Tue, 23 Nov 1999 17:31:39 GMT
Message-ID: <383ACFB6.D73EDAF8_at_gte.net>
[Quoted] [Quoted] I have a Developer 2000, Windows NT, Oracle Server version 7, application that I execute update procedures out of a Validation Trigger. The problem is that the update procedure hangs - instead of executing an On Error Trigger - when one of the records to be updated is being edited in another instance of my application. A further description is as follows:
When running two instances of my application, the first instance was locked onto (editing) a record that I knew that the second instance was going to update. When following the breakpoints of the second instance, it got to the update procedure (called out of the validation trigger) and the screen froze. I have 'on error' triggers set on the item that triggered the update procedure, on the block of this item. The 'on error' trigger will display an alert which will require a response from the user. None of these alerts was executed.
What is happening is that my update (implicit) query is hanging - On Error trigger is not executed - because the record I am trying to update is locked by another user. Only when the first instance of my application disconnects will the update query run to completion. My gut feeling is that Oracle never expected Update Queries to be executed out of validation triggers. Has anyone been able to do this? Received on Tue Nov 23 1999 - 18:31:39 CET