Start of change

-147   ALTER FUNCTION function-name FAILED BECAUSE SOURCE FUNCTIONS OR SPATIAL FUNCTIONS CANNOT BE ALTERED

Explanation

The function cannot be altered because it is a source function or a spatial function. Only fenced external scalar functions, or fenced external table functions can be altered.

To change an existing source function or spatial function, you must DROP the function and re-create it.

System action

The statement cannot be processed.

Programmer response

Change the statement to refer to a function that can be altered, or re-create the function by dropping it and then creating a new version of it.

SQLSTATE

42917

End of change