"newContext Function" |
Creates a new context handle from a passed-in SQL query. The context handle can be used for the rest of the functions. |
"setRowTag Procedure" |
Sets the name of the element enclosing each row of the result. The default tag is ROW. |
"setRowSetTag Procedure" |
Sets the name of the element enclosing the entire result. The default tag is ROWSET. |
"getXML Procedure" |
Appends the XML to the CLOB passed in. Use the getNumRowsProcessed function to figure out if any rows were appended. |
"getXML Function" |
Returns the XML as a CLOB. |
"getNumRowsProcessed Function" |
Gets the number of SQL rows that were processed in the last call to getXML. |
"setMaxRows Procedure" |
Sets the maximum number of rows to be fetched each time. |
"setSkipRows Procedure" |
Sets the number of rows to skip every time before generating the XML. The default is 0. |
"setConvertSpecialChars Procedure" |
Sets whether special characters such as $, which are non-XML characters, should be converted or not to their escaped representation. The default is to perform the conversion. |
"useItemTagsForColl Procedure" |
Forces the use of the collection column name appended with the tag _ITEM for collection elements. The default is to set the underlying object type name for the base element of the collection. |
"restartQUERY Procedure" |
Restarts the query to start fetching from the beginning. |
"closeContext Procedure" |
Closes the context and release all resources. |