The number of SQLs you send needs to be relatively small for this to potentially outperform the temp table approach. It should be o.k. for 10K keys.
If it's for character then just also add single quotes around the values.
keylist=catx(',',keylist,cats("'",key,"'"));
... View more
