DynasetCacheParams Method

Applies To

OraParameter Object


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


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


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.


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.