Start of change

-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

End of change