FNC_SetXML Function | C Library Functions | Teradata Vantage - 17.10 - FNC_SetXML - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL External Routine Programming

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

Set the value of an XML type.


FNC_SetXML(XML_HANDLE      xmlHandle,
           byte          *xmlBuffer,
           int             xmlSize)

Syntax Elements

A handle to an XML type that is defined to be a return value for a UDF/UDM or an INOUT/OUT parameter to an external stored procedure.
A pointer to the XML value to be set.
The total size in bytes of the XML value.

Usage Notes

FNC_SetXML is used to set an XML return value or OUT parameter value using a memory buffer.

The XML handle xmlHandle is passed as input along with a pointer to the XML value. The XML value must be in the UNICODE character set.

Note that the XML value that is passed to this routine must contain well-formed XML data, otherwise you will get an error.

FNC_SetXML can only be called for inline XML values, that is XML values that are less than 64K, otherwise you will get an error.