Re: OCI - a tough one...

not that it's a good fix.. but what platform are you on. there is no 64K limit that I know of. I just ran a 75K stmt (split over 1,204 lines) as input to SQL*Plus and it worked just fine.

In article <33442C28.7DA5_at_ibm.net>, Dan Shechter <shecht_at_ibm.net> 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.
Received on Fri Apr 11 1997 - 00:00:00 CDT