| |
- Causa
- IN CREATE FUNCTION FOR function-name STATEMENT, THE NUMBER OF PARAMETERS DOES NOT MATCH THE NUMBER OF PARAMETERS OF THE
SOURCE FUNCTION
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.
- Ação do sistema
- The statement cannot be executed.
- Resposta ao Desenvolvedor
- 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 current path needs to be corrected in order for correct function resolution to occur.
SQLSTATE: 42885
© Copyright IBM Corp.
|
| |
