New XML Table Function wizard - Options page

Use the Options page of the New XML Table Function wizard to specify whether you want to perform XSL transformation on the XML document before it is processed by the UDF. Either the content of the XSL stylesheet or the file name of the stylesheet can be used as the input parameter to the UDF. To use the content of the stylesheet, choose CLOB. To use the file name of the stylesheet, choose VARCHAR. You can also save the specified column paths, column names, and datatype definitions to a file to be used the next time you create a UDF with this wizard.
Perform XSL transformation on the XML document
Select to have the XML document that is input to the user-defined function go through an XSL transformation before being processed by the user-defined function.
CLOB
Specifies that the data type for the XSL document (stylesheet) input parameter is a CLOB. A CLOB (character large object) is a sequence of characters (single-byte, multibyte, or both) with a size ranging from 0 bytes to 2 gigabytes less 1 byte. In general, CLOB values are used whenever a character string might exceed the limits of the VARCHAR type.
Length
Type the length for the XSL document input parameter. The maximum length is 4 megabytes.
Unit
Select a unit for your length.
VARCHAR
Specifies that the data type for the XSL document (stylesheet) input parameter is a VARCHAR.
Length
Type the length for the XSL document input parameter. The maximum length is 4 megabytes.
Save the paths and column definitions to a file
Specifies to save the column paths, column names, and datatype definitions to a file. This file can be used next time you create a user-defined function using this wizard to avoid re-entering the column paths, column names, and datatype definitions.
File name
Specify the file name.

Feedback