Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_XMLGEN, 9 of 13
This procedure skips a given number of rows before generating the XML output for every call to the getXML
routine.
DBMS_XMLGEN.setSkipRows (ctx IN ctxHandle, skipRows IN NUMBER);
Table 71-9 shows the parameters of the setSkipRows
procedure.
Parameter | Description |
---|---|
|
The context handle corresponding to the query executed. |
|
The number of rows to skip per call to |
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.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|