-20556 THE OPERATION FAILED BECAUSE MULTIPLE RESULT VALUES CANNOT BE RETURNED FROM A SCALAR FUNCTION function-name.
Explanation
A scalar function was invoked with arguments that do not allow the return of multiple result values for a single invocation. The processing of the scalar function determined a result the consisted of multiple values.
- function-name
- Identifies the name of the function that returned the error.
System action
The statement cannot be processed.
User response
One of the following options can be used to avoid
the error:
- Change the values of the input arguments to the scalar function to return a single value from the multiple value result.
- As an alternative to the scalar function invocation, create a user-defined table function, if possible, to return a result with multiple values.
SQLSTATE
22547
