-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