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

Home -> Community -> Usenet -> c.d.o.misc -> Re: OCI - a tough one...

Re: OCI - a tough one...

From: Peter vR. Cooper <pvrc_at_vrcis.com>
Date: 1997/04/04
Message-ID: <334522A4.170D@vrcis.com>#1/1

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. Received on Fri Apr 04 1997 - 00:00:00 CST

Original text of this message

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