Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Binding a list
There is a note on my website describing how
to do this with Object Table Types and the
cast() and table() functions.
I haven't tried applying the principle in OCI though
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
srobidou_at_yahoo.fr wrote in message <880rbh$qe$1_at_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 - 06:43:00 CST