-483 IN CREATE FUNCTION FOR function-name STATEMENT, THE NUMBER OF PARAMETERS DOES NOT MATCH THE NUMBER OF PARAMETERS OF THE SOURCE FUNCTION
Explanation
An attempt is being made to CREATE a user-defined
function function-name which is sourced on another
function. One of the following situations has been identified:
- The SOURCE clause uses a function-name (input parameter list) to identify the source function, and the number of types in the list is different from the number of parameters of the function being created.
- The SOURCE clause uses different syntax to identify the source function, and the number of types of that function is different from the number of parameters of the function being created.
System action
The statement cannot be processed.
Programmer response
The number of parameters for the SOURCE
function and for the function being created must be the same. The
identification of the SOURCE function needs to be changed to:
- fix the input parameter list
- correct the function name or function specific name to identify the proper function.
It is also possible that the SQL path needs to be corrected in order for correct function resolution to occur.
SQLSTATE
42885