Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Binding a list

Re: Binding a list

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 11 Feb 2000 12:43:00 -0000
Message-ID: <950273158.24298.0.nnrp-07.9e984b29@news.demon.co.uk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US