Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Locking Issues/Release in Forms 10g R2

453401Feb 28 2008 — edited Mar 3 2008

Hi all,

We are using 10g R2 AS and oracle database 10g.
Give me a good solution to prevent locking. User A is accessing one form(using execute_query, form built-in insert_record etc) and he is not coming out of the form for a long time. In this case, User B, C , D..are trying and they have to wait in the queue. In this case, we are forcefully killing user A session.Suppose his changes are not saved ie he might have entered inter-linked information in form 1,2, and working on 3. That time we are killing his session because of other users queues.
So in this case , we cannot communitcate with each user(users are plenty) to come out of the screen. Better to introduce time-out in forms level. Can you please give an idea to overcome this problem...?I have no knowledge in lock handling.

Regards
Priya

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 31 2008

Added on Feb 28 2008

#forms, #moved-from-devops

16 comments

1,541 views