Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 FRANCEReceived on Tue Jan 21 1997 - 00:00:00 CST