TD_SYSXML.XMLPUBLISH (
queryString,
Xslt,
XmlString,
resultCode
)
Syntax Elements
- queryString
- The SQL query string whose results are published in XML format.
- IN parameter of data type VARCHAR(20000), CHARACTER SET UNICODE.
- If queryString is NULL, the XmlString return value will be NULL.
- Xslt
- The XSLT stylesheet representing the mapping from the tabular model of the SQL query result set to the tree model of the XML output.
- IN parameter of data type XML.
- The Xslt argument is an XML type instance representing a consolidated stylesheet or simply a stylesheet if it does not use stylesheet includes. This stylesheet should map the user query results to the desired XML output.
- If Xslt is NULL, the XmlString return value is the XML resulting from canonical publishing.
- XmlString
- The string representation of XML output.
- IN parameter of data type CLOB, CHARACTER SET UNICODE.
- resultCode
- XMLPUBLISH returns a result code as follows:
- 0 indicates success
- -1 indicates failure
- OUT parameter of data type INTEGER.