setMaxRows Procedure

This procedure sets the maximum number of rows to fetch from the SQL query result for every invokation of the getXML call.

Syntax

DBMS_XMLGEN.setMaxRows (

ctx  IN ctxHandle,
maxRows  IN NUMBER);

Parameters

Table 71-8 shows the parameters of the setMaxRows procedure.

Table 71-8 SET_MAX_ROWS Procedure

Parameter	Description
ctx (IN)	The context handle corresponding to the query executed.
maxRows (IN)	The maximum number of rows to get per call to getXML.

Usage Notes

Closes all resources associated with this handle. After closing the context, you cannot use the handle for any other DBMS_XMLGEN function call.