Binding a list

From: <srobidou_at_yahoo.fr>
Date: Fri, 11 Feb 2000 11:21:23 GMT
Message-ID: <880rbh$qe$1@nnrp1.deja.com>

Hello,

I am working with Oracle 8i and I would like to execute a query like

SELECT X FROM Y WHERE Z IN(:1) ; using OCI, where :1 would be an array or list of scalar(1,2,3,4,...).

Is it possible to do this using OCIBindByPos ? and do I have to set the iter parameter of StmtExecute to the length of this array:

So far the tests I have performed didn't work. Has someone an idea ???

Thanks in advance

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Feb 11 2000 - 05:21:23 CST