Re: OCI - a tough one...

Peter vR. Cooper <pvrc_at_vrcis.com> wrote in article <334522A4.170D_at_vrcis.com>...
> Dan Shechter wrote:
> >
> > Greetings OCI wizards...
> >
> > Does anyone know how to bind an array of input variables while binding
 a
> > different array of output variables ?
> >
> > Or in english: I need to read many rows from a table, while my
 condition
> > contains a field with many possible values.
> >
> > I can't just use a simple SQL statement like this:
> > "select my_field from my_table where my_other_field in ...."
> > because SQL statements are limited in size to 64KB, while my condition
> > easily surpasses that limit.
> >
> > If this (binding *both* input and output arrays) is not possible via
> > OCI, can someone tell me if and how can it be done using PL/SQL?
> >
> > I need of desparate help.
> > Dan.
>
> If I understand the problem, I think you may have to serially
> process more than one set of where clause variables (messy) and
> reparse and bind the variables on every set of where clause conditions.
>

How about using temporary table to hold all your conditions, then join that temporary in a sub query. Received on Fri Apr 04 1997 - 00:00:00 CST