Article View: comp.databases.oracle.server
Article #29Re: How to aggregate PL/SQL records into a Result Set?
From: oblomov
Date: Wed, 10 Jul 2002 11:40
Date: Wed, 10 Jul 2002 11:40
20 lines
2455 bytes
2455 bytes
On 9 Jul 2002 14:01:17 -0700 igoriz@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
Technical Details
Message-ID:
<20020710134030.0077d8bc.spam@oblomov.org>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!sn-xit-05!sn-xit-03!sn-xit-06!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mailReferences:
<c9bc36ff.0207071227.141865fc@posting.google.com> <agaa3m0ahj@drn.newsguy.com> <457W8.6770$Qt6.589048@wagner.videotron.net> <c9bc36ff.0207081836.29106794@posting.google.com> <9f17469e.0207091301.7fb8bf23@posting.google.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fa4f9,7c58a4418eab2433 X-Google-Attributes: gidfa4f9,public X-Google-Thread: f99a8,7c58a4418eab2433 X-Google-Attributes: gidf99a8,public X-Google-Thread: 1073da,7c58a4418eab2433 X-Google-Attributes: gid1073da,public X-Google-Thread: 107d46,7c58a4418eab2433 X-Google-Attributes: gid107d46,public X-Google-Thread: 10a146,7c58a4418eab2433 X-Google-Attributes: gid10a146,public X-Google-ArrivalTime: 2002-07-10 04:43:40 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!sn-xit-05!sn-xit-03!sn-xit-06!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: oblomov <spam@oblomov.org> Newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc,borland.public.jbuilder.database,comp.lang.java.databases,comp.lang.java.programmer Subject: Re: How to aggregate PL/SQL records into a Result Set? Date: Wed, 10 Jul 2002 13:40:30 +0200 Organization: oblomov.org Message-ID: <20020710134030.0077d8bc.spam@oblomov.org> References: <c9bc36ff.0207071227.141865fc@posting.google.com> <agaa3m0ahj@drn.newsguy.com> <457W8.6770$Qt6.589048@wagner.videotron.net> <c9bc36ff.0207081836.29106794@posting.google.com> <9f17469e.0207091301.7fb8bf23@posting.google.com> X-Newsreader: Sylpheed version 0.7.8 (GTK+ 1.2.10; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Complaints-To: newsabuse@supernews.com Lines: 20