DynasetCacheParams Method

Applies To

Description

Specifies the dynaset cache and fetch parameters for the dynaset created from the PL/SQL cursor.

Usage

oraparameter.DynasetCacheParams SliceSize,perblock, Blocks, FetchLimit,FetchSize

Arguments

The arguments for the method are:

Arguments	Description
`SliceSize`	Cache slice size.
`perblock`	Cache slices for each block.
`Blocks`	Cache maximum number of blocks.
`FetchLimit`	Fetch array size.
`FetchSize`	Fetch array buffer size.

Remarks

This method should be called before executing the PL/SQL procedure containing a cursor variable. By default, the dynaset is created with default cache and fetch parameters specified in the registry.