如何将逗号分隔的列表传递给存储过程？

所以我有一个Sybase存储的proc，它带有1个参数，该参数是逗号分隔的字符串列表，并在IN（）子句中使用in运行查询：

CREATE PROCEDURE getSomething @keyList varchar(4096)
AS
SELECT * FROM mytbl WHERE name IN (@keyList)

如何在列表中调用具有大于1的值的存储过程？到目前为止，我已经尝试过

exec getSomething 'John'         -- works but only 1 value
exec getSomething 'John','Tom'   -- doesn't work - expects two variables
exec getSomething "'John','Tom'" -- doesn't work - doesn't find anything
exec getSomething '"John","Tom"' -- doesn't work - doesn't find anything
exec getSomething '\'John\',\'Tom\'' -- doesn't work - syntax error