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.