prepared statements, IN, Arrays and you

From: <henricks_at_my-deja.com>
Date: Thu, 11 Nov 1999 00:41:35 GMT
Message-ID: <80d3bv$p2v$1@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 Wed Nov 10 1999 - 18:41:35 CST