Skip to Main Content

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!

Question about LOVs and "Record Group Fetch Size" property

529448Apr 23 2007 — edited Aug 17 2013
Hi:

For some reason, in our application, a couple of users have been sporadically experiencing the following issue with and LOV:

They invoke the LOV. Note: Query associated with the LOV retrieves 750 rows.
They used the scrollbar to move down the list. At some point during the scroll, their screen turns white and stays white for several minutes.

A couple of days ago I had a chat with one of my friends from a previous job and he told me that when they converted to forms on the web, they observed this behavior and that he was pretty certain that this was due to a property associated with the LOV. I looked at all the properties associated with the LOV object and none strikes me as being related. I did find the "Record Group Fetch Size Property" in the record group and it seems to be related. Does anyone know if indeed this property has a connection to our behavior?

My friend also told me that they basically had to create an LOV look alike solution using a form block. I believe I saw a solution doing this a while ago. Does anyone know where I may find it?

Thanks,

Thomas
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 14 2013
Added on Apr 23 2007
4 comments
1,400 views