OCI - a tough one...

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 04 1997 - 00:00:00 CST