-492 THE CREATE FUNCTION FOR function-name HAS A PROBLEM WITH PARAMETER NUMBER number. IT MAY INVOLVE A MISMATCH WITH A SOURCE FUNCTION
Explanation
The parameter in position number of function function-name is in error.
- function-name
- The name of the function that cannot be created.
- number
- The position number of the function parameter that has the problem.
This error is issued in the following circumstances:
- The parameter of the source function is not castable to the corresponding
parameter of the function being created.
If the parameter of the function being created is a table parameter, the corresponding parameter of the source function must also be a table parameter. Furthermore, the column numbers for both of the table parameters must be the same.
If the parameter of the function being created is not a table parameter, the corresponding parameter of the source function must also not be a table parameter.
System action
The statement cannot be processed.
Programmer response
Possible corrections include:
- Identify a different source function.
- Change the data type of the parameter of the function being created so that the data type of the source function can be cast to this data type.
SQLSTATE
42879