setSkipRows Procedure

This procedure skips a given number of rows before generating the XML output for every call to the getXML routine.

Syntax

DBMS_XMLGEN.setSkipRows (

ctx  IN ctxHandle,
skipRows  IN NUMBER);

Parameters

Table 71-9 shows the parameters of the setSkipRows procedure.

Table 71-9 setSkipRows Procedure Parameters

Parameter	Description
ctxHandle (IN)	The context handle corresponding to the query executed.
skipRows (IN)	The number of rows to skip per call to getXML.

Usage Notes

You can use the skipRows parameter when generating paginated results for stateless Web pages using this utility. For example, when generating the first page of XML or HTML data, you can set skipRows to zero. For the next set, you can set the skipRows to the number of rows that you got in the first case.