setRaiseNoRowsException Procedure

This procedure tells the XSU whether or not to throw an OracleXMLNoRowsException when the XML document generated is empty. By default, the exception is not thrown.

Syntax

DBMS_XMLQUERY.setRaiseNoRowsException (

ctxHdl  IN ctxType, 
flag  IN BOOLEAN);

Parameters

Table 72-23 shows the parameters of the setRaiseNoRowsException procedure.

Table 72-23 setRaiseNoRowsException Procedure Parameters

Parameter	Description
ctxHdl (IN)	The context handle.
flag (IN)	throw OracleXMLNoRowsException if no data?