Re: binding values in IN(:1, :2,:3)

From: Norbert <usun_to.norbert_at_exbud.com.pl>
Date: Tue, 27 Mar 2001 14:13:56 +0200
Message-ID: <99q011$rse$1@news.tpi.pl>

my advice:
store parameters into a database table and then where sth_id in (select ... )

greets

Norbert

U¿ytkownik "Rene Nyffenegger" <rene.nyffenegger_at_audatex.KEINESPAM.ch> napisa³ w wiadomo¶ci news:996as2$730$1_at_news1.sunrise.ch...
> Hi
>
> I am trying to bind values in the IN clause of an SQL statement
> using OCI.
>
> select sth from stbl where sth_id in (:1, :2, :3)
>
> Almost needless to say that the count of parameters in the in clause
> varies.
>
> Can that be achieved and if yes: how
>
> tia
>
> Rene
>
>
>
Received on Tue Mar 27 2001 - 06:13:56 CST