OCI - a tough one...
From: Dan Shechter <shecht_at_ibm.net>
Date: 1997/04/04
Message-ID: <33442C28.7DA5_at_ibm.net>#1/1
Date: 1997/04/04
Message-ID: <33442C28.7DA5_at_ibm.net>#1/1
[Quoted] [Quoted] [Quoted] Greetings OCI wizards...
Does anyone know how to bind an array of input variables while binding a [Quoted] different array of output variables ?
Or in english: I need to read many rows from a table, while my condition [Quoted] 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 CEST