|Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)
Part Number A89852-02
DBMS_METADATA , 4 of 11
SET_COUNT specifies the maximum number of objects to be retrieved in a single
FETCH_xxx call. By default, each call to
FETCH_xxx returns one object.
SET_COUNT allows you to override this default. If
FETCH_xxx is called from a client, specifying a count value greater than 1 can result in fewer server round trips and, therefore, improved performance. Note that the procedure stops when
NULL is returned, but not if less than the maximum number of objects is returned.
The handle returned from
The number of objects to retrieve.
NULLor invalid value was supplied for an input parameter. The error message text identifies the parameter.
SET_COUNTwas called after the first call to
OPENcontext. After the first call to
FETCH_xxxis made, no further calls to
SET_COUNTfor the current
OPENcontext are permitted.