Syntax
public class class_name {
...
public static result_type method_name (
[ type input_param [,...] ]
)
{
...
}
}
Syntax Elements
- class_name
- Java class name.
- result_type
- Java primitive or class corresponding to the SQL data type in the RETURNS clause of the corresponding CREATE FUNCTION statement.
- method_name
- Java method name.
- type
- Data type of input_param, a Java primitive or class corresponding to the SQL data type of the input argument.
- input_param
- Input parameter for Java method. The method signature must have an input_param for each parameter in the CREATE FUNCTION statement.
- The maximum number of input parameters is 128.