A script-enabled browser is required for this page to function properly.

About Array Processing

Array processing is an option in Oracle Forms that alters the way records are processed. The default behavior of Oracle Forms is to process records one at a time. By enabling array processing, you can process groups of records at a time, reduce network traffic and increase performance. With array processing, a structure (array) that contains multiple records is sent to or returned from Oracle Forms Services for processing. Oracle Forms supports both array fetch processing and array DML processing. For both querying and DML operations, you can determine the array size to optimize performance for your needs.

Array processing is available for query and DML operations for blocks based on tables, views, procedures, and sub-queries with default Forms processing; it is not supported for blocks based on stored procedures.


About trigger processing during array DML processing

Enabling array processing for queries

Enabling array processing for DML

DML Array Size property

Query All Records property