Re: Alternate for Varrays in Oracle

[carl christianson]

I've seen this reply before.
Not to put words in the posters mouth.

But that's not the same thing. If you have an application and you wish to pass a set of values to a stored procedure. You are doing so
because perhaps you pass 1000 values, in one network round trip.

The database then can do a batch routine with those values with no more network round trips necessary.

I would like to know if there is a reasonable way to accomplish this sort of thing.

Rather then, say, do 1000 statements across the network into a table for your procedure to read. Even batched up in jdbc that's a significant difference in performance.

Sure you could try something kinda hokey like pass a delimited string that you'd have to parse on the recieving side. But that's not exactly a great approach either.

I would love to know if there is a way to do this sort of thing.