OraFAQ Forum: Forms » Third level block handling in oracle forms 6i

Home » Developer & Programmer » Forms » Third level block handling in oracle forms 6i (Forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Third level block handling in oracle forms 6i [message #462558]

Thu, 24 June 2010 22:46

naveen.wason
Messages: 7
Registered: December 2008
Location: Delhi

Junior Member

I have created Master Detail form of Sales offer. I would like to enter item detail under Sales offer detail.

Example :

Sales Offer Header -> Sales Offer Detail -> Sales Offer Detail Detail.

I have tried to make a form in form 6i to fulfill above mention scenario. But when two or multiple users tried to enter data from this form all users entered into deadlock or hang stage. Kindly provide solution for above mention requirement.

Report message to a moderator

Re: Third level block handling in oracle forms 6i [message #462596 is a reply to message #462558]

Fri, 25 June 2010 04:11

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

We would need to know which records are getting locked.

Report message to a moderator

Re: Third level block handling in oracle forms 6i [message #462615 is a reply to message #462596]

Fri, 25 June 2010 04:47

naveen.wason
Messages: 7
Registered: December 2008
Location: Delhi

Junior Member

Complete Table of Third block getting locked. I need one sample form. Because i did not use third level of block in form 6i.

Report message to a moderator

Re: Third level block handling in oracle forms 6i [message #462619 is a reply to message #462615]

Fri, 25 June 2010 04:54

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

It shouldn't be.
Oracle only locks the specific records you are trying to change. It locks them as soon as you start modifying them and releases the lock when you commit. That's the default behaviour.

Are the users querying the same set of records in the 2nd block?

Report message to a moderator

Re: Third level block handling in oracle forms 6i [message #462637 is a reply to message #462619]

Fri, 25 June 2010 07:02

naveen.wason
Messages: 7
Registered: December 2008
Location: Delhi

Junior Member

Oracle only locks the specific records you are trying to update/delete but when some one inserting any record in that table oracle locks the complete table till commit/rollback.

Report message to a moderator

Re: Third level block handling in oracle forms 6i [message #462639 is a reply to message #462637]

Fri, 25 June 2010 07:18

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Again that shouldn't happen.
Is it just the 3rd block that does that or all three?
Do you have any pre/post-insert forms triggers on the problem block?
Do you have any insert database triggers on the table the problem block is based on.

Report message to a moderator

Re: Third level block handling in oracle forms 6i [message #462649 is a reply to message #462639]

Fri, 25 June 2010 08:14

naveen.wason
Messages: 7
Registered: December 2008
Location: Delhi

Junior Member

We have pre insert trigger in first ,second and third block.

All blocks of form in lock.

Report message to a moderator

Re: Third level block handling in oracle forms 6i [message #462651 is a reply to message #462649]

Fri, 25 June 2010 08:18

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Ok so what does the pre-insert trigger actually do?

Report message to a moderator

Re: Third level block handling in oracle forms 6i [message #462712 is a reply to message #462651]

Fri, 25 June 2010 23:00

naveen.wason
Messages: 7
Registered: December 2008
Location: Delhi

Junior Member

It just putting primary key value from forms in all blocks.

Report message to a moderator

Re: Third level block handling in oracle forms 6i [message #462730 is a reply to message #462712]

Sat, 26 June 2010 04:16

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Exact code please - I really can't diagnose an issue with incomplete information.

You've got some code somewhere that's doing the locking, oracle's only doing this because you told it to, and the pre-insert trigger is the most likely culprit at this point.

Report message to a moderator

Re: Third level block handling in oracle forms 6i [message #465170 is a reply to message #462730]

Tue, 13 July 2010 01:45

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Sorry that I have been so long in replying. Have you solved your problem?

Perhaps you should move that code to a database trigger.

David

Report message to a moderator

Previous Topic:	using Webutil to get ip address on form load
Next Topic:	call batch file from Oracle Forms 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:40:53 CDT 2024