It’s illegal to pass a list parameter to anything other than the IN predicate. Just remove the coalesce part. There is no need for that anymore.