Oracle Forms

Hi all,

I've a form which consists of 4 blocks, where in 3 blocks have the table as the data base blocks(Master-Child-Grand Child relationship). One is a control block. Problem I'm facing is the form is placing the table level lock. I've a situation like this.

1.User1 queries for a record and then modifies the record
2.User2 queries for another record and modifies it. and issues a commit.

In this situation the application of the user2 will be in hanging mode. Unless the user1 does not come out, the user2 will be in the same state.
When i view the blocking locks using the toad, I find that the User1 is blocking User2 from updating the record. The problem is we've almost 10 users using this form at a time.

I was just checking this issue. When I wrote the Null; in the On-Lock trigger of the third block(Grand Child Record) the it started to allow the saving the records of the user2 irrespective of the state of the User1.

To check the problematic area, I've made the Grand Child block as the Non data base block. then the user2 was able to save the record, irrespective of the commit/Rollbacks issued by the User1.

I just wanted to know, What would be the repercussions of this code(i.e.. Null statement in the On-Lock trigger of the Grand Child block).

I'm using Forms 6i and Oracle 10g R2.

Regards,
Alok Dubey

Edited by: Alok Dubey on Nov 14, 2009 4:35 PM

Edited by: Alok Dubey on Nov 14, 2009 4:38 PM

Edited by: Alok Dubey on Nov 14, 2009 4:55 PM