NetComrade wrote:
> Daniel,
>
> The problem was described in the original post. Basically we wanted to
> pass arrays of records back to pro*c, and in current implementation
> you'd have to fetch one by one, while fetching from a table (such as
> temporary) could be done in batches. Right now we're ditching Oracle
> arrays, and are going to pass everything back in one variable (limited
> to 32K in pl/sql), and parse it in pro*c. The reason for dealing with
> 'arrays' is to move some of the complex business logic into PL/SQL to
> avoid numerous sql*net roundtrips between db and client (pro*c).
>
> -Andrey.
>
Why can't you pass REF CURSORS?
Why can't you pass PL/SQL tables?
Why can't you store the values in a package and work with them there?
And why do you have a 32K limit? 4GB I could understand but not 32K.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Mon Dec 08 2003 - 16:34:05 CST
