Publishes SQL query results in an XML format specified by the user.
Required Privileges
The XMLPUBLISH stored procedure is created under the user TD_SYSXML.
The user invoking this stored procedure must have the following privileges:
- EXECUTE PROCEDURE on TD_SYSXML
- SELECT privilege on the staging table
- GRANT ALL (insert/update/delete/upsert) on the target tables
Syntax
TD_SYSXML.XMLPUBLISH ( queryString, Xslt, XmlString, resultCode )
| Parameter Name | Parameter Type | Data Type | Description |
|---|---|---|---|
| queryString | IN | VARCHAR(20000) CHARACTER SET UNICODE |
The SQL query string whose results are published in XML format. |
| Xslt | IN | XML | The XSLT stylesheet representing the mapping from the tabular model of the SQL query result set to the tree model of the XML output. |
| XmlString | OUT | CLOB CHARACTER SET UNICODE |
The string representation of XML output. |
| resultCode | OUT | INTEGER | XMLPUBLISH returns a result code as follows:
|