public class class_name { ... public static result_type method_name ( type_1 input_param_1, ..., type_n input_param_n) { ... } }
where:
| Return Type/Parameter … | Specifies … |
|---|---|
| result_type | a Java primitive or class corresponding to the SQL data type in the RETURNS clause of the corresponding CREATE FUNCTION statement. |
| type_n input_param_n | the input parameters, where n is the number of parameters in the CREATE FUNCTION definition. If n = 0, no input parameters appear. The type is a Java primitive or class corresponding to the SQL data type of the input argument. The maximum number of input parameters is 128. |