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?