PRO*C QUESTION: dynamic IN clause

Hi everybody,

I would like to make a query in PRO*C with an IN clause ,for example: EXEC SQL select count(*) into :var from table where xxx in (:liste);

liste is a varchar variable passed in parameter to the PRO*C.

Unfortunately, it does NOT work...

Any idea to solve that simple problem ?

Please answer by mail too. Tanks a lot

-- 
Laurent CITTON       (citton_at_shom.fr)
E.P.S.H.O.M          (www.shom.fr)
13 rue du Chatellier
BP 426
29275 BREST cedex
FRANCE