Re: prepared statements, IN, Arrays and you

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 11 Nov 1999 08:52:57 -0000
Message-ID: <942311205.14373.0.nnrp-07.9e984b29@news.demon.co.uk>

Have a look on my web-site. I think
the item on 'a list of values as a single variable' answers your question

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

henricks_at_my-deja.com wrote in message <80d3bv$p2v$1_at_nnrp1.deja.com>...
>Hi all,
>I am trying to use a prepared statement with an "IN" clause with Oracle
>8i. I know that I can not dynamically determine how many entries would
>be in the clause to create the correct number of substitution, ie IN
>(?, ?, ?), nor do I have a maximum number of possible entries which
>will be used. My question goes like this. Is there some what I can do
>the same thing using an array? Any help would be much appreciated.
>Thanks.
>
>Brad
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Thu Nov 11 1999 - 02:52:57 CST