Query Array Size Property
Description
Specifies the maximum number of records that Oracle Forms should fetch from the database at one time.
Applies to block
Set Oracle Forms
Refer to Built-in
GET_BLOCK_PROPERTY
The number of records the block can display, as indicated by the Number of Records Displayed block property.
Required/Optional required
Usage Notes
- A size of 1 provides the fastest perceived response time, because Oracle Forms fetches and displays only 1 record at a time. By contrast, a size
of 10 fetches up to 10 records before displaying any of them, however, the
larger size reduces overall processing time by making fewer calls to the database
for records.
Query Array Size Restrictions