getNumRowsProcessed Function

This function gets the number of SQL rows processed when generating the XML using the getXML call. This count does not include the number of rows skipped before generating the XML.

Syntax

DBMS_XMLGEN.getNumRowsProcessed (

ctx  IN ctxHandle)

RETURN NUMBER;

Parameters

Table 71-7 shows the parameters of the getNumRowsProcessed function

Table 71-7 getNumRowsProcessed Function Parameters

Parameter	Description
queryString (IN)	The query string, the result of which must be converted to XML.

Returns

The number of rows processed in the last call to getXML. This does not include the number of tows skipped.

Usage Notes

Use this function to determine the terminating condition if you are calling getXML in a loop. Note that getXML always generates an XML document, even if there are no rows present.