DynasetCacheParams Method

Applies To

OraParameter

Description

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

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.

Usage

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

Remarks

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