Re: Oracle Form: Master-Detail Relationship

From: Yuri Ivanov <>
Date: Wed, 05 Oct 2005 21:47:31 +0400
Message-ID: <di13ih$27u$>

Pat пишет:
> Hi All,
> I have a question on Oracle Forms (version 6i) for your comment.
> When I build a master and a detail block, link it up with a relation,
> some triggers will be generated by oracle forms, e.g. on-populate-details,
> which query the detail block automatically when the master block is queried.
> However, it used "go_block", "execute_query" to populate the data which
> I found it has performance problem in forms processing. Imagine I have
> a master block with 5 detail blocks, that might impose quite some network
> traffic which makes the forms "run" very slowly.
> Are there any alternatives for such processing?
> Thx.
Hi! You can remove all auto-generated triggers and replace it with your. But you must be very accuracy. It is not easy job :) And one more. _IMHO_ you got slow work not because these triggers - check your queryes and database structures :) I told this, because I have expirience with character-mode forms on 9600 tty - it work very quickly by itself :)
Good luck! Received on Wed Oct 05 2005 - 19:47:31 CEST

Original text of this message