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.
PROCEDURE set_count ( handle IN NUMBER, value IN NUMBER);
Parameter | Description |
---|---|
|
The handle returned from |
|
The number of objects to retrieve. |
INVALID_ARGVAL
. A NULL
or invalid value was supplied for an input parameter. The error message text identifies the parameter.
INVALID_OPERATION
. SET_COUNT
was called after the first call to FETCH_xxx
for the OPEN
context. After the first call to FETCH_xxx
is made, no further calls to SET_COUNT
for the current OPEN
context are permitted.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|