Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to aggregate PL/SQL records into a Result Set?
On 9 Jul 2002 14:01:17 -0700
igoriz_at_cmtk.net (Igor Izvekov) wrote:
> You may want to look at global temporary tables. They can be accessed
> by the same name by many sessions, yet data there will be private to
> each session. After session completes, data is gone. Using PL/SQL
> tables (similair to an array)is also a possibility. You can create a
> function which will populate such a table with results of some query
> and then return this table. With a little trick you can even select
> from this function.
I still think he is looking for the CURSOR. That way you don't have to bother about making tempoarary tables and who knows what to slow down the already so slow Oracle. It is done the same way with PostgreSQL as with Oracle and I've done it with booth of them.
Look for PL/SQL CURSOR or PostgreSQL RefCursor
You might want to make your own ProxyCallableStatement and ProxyConnection to get everything run smooth.
karl Received on Wed Jul 10 2002 - 06:40:30 CDT