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.