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.