Error when passing multiple values
This is one (of many) situation where Stored Routines are less useful than one would like.

A possible workaround:  Build a VIEW without the IN clause, then use the IN clause when fetching from the VIEW.