PRO*C QUESTION: dynamic IN clause
From: Citton Laurent <citton_at_shom.fr>
Date: 1997/01/21
Message-ID: <5c295g$eim_at_oceanie.shom.fr>#1/1
Date: 1997/01/21
Message-ID: <5c295g$eim_at_oceanie.shom.fr>#1/1
[Quoted] 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 FRANCEReceived on Tue Jan 21 1997 - 00:00:00 CET