Re: How to aggregate PL/SQL records into a Result Set?

Article View: comp.databases.oracle.server

Article #27

Back to comp.databases.oracle.server Previous Next

#27

From: oblomov
Date: Tue, 09 Jul 2002 18:16

22 lines
2279 bytes

> > My PL/SQL script uses a table called 'tempGUI' which is populated
> > one record at a time, and its contents are removed after being sent
> > to the client (actually, the deleting the old table is the very
> > first thing done).  The obvious problem is name collision.
> > What if two clients access the stored procedure at the same time?
> > Is there any way to have a private table (visible by only one
> > instance of the stored procedure)?  Or even better, is there some
> > sort of RAM-based table?
> >
> > BTW: I intend to implement the PIPELINED approach as soon as I have
> > Oracle 9i up and running, but for now I am using the approach
> > that you suggested.  Again, I am worried about simultaneous access.
> >
> > Thanks,
> >
> > -Ramon

  Maybe it is the REFCURSOR (just CURSOR?) you are looking for?



karl

Technical Details

Message-ID: <20020709201622.064ab7ef.spam@oblomov.org>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail

References:

<c9bc36ff.0207071227.141865fc@posting.google.com> <agaa3m0ahj@drn.newsguy.com> <457W8.6770$Qt6.589048@wagner.videotron.net> <c9bc36ff.0207081836.29106794@posting.google.com> <3D2B2142.EC54B769@oracle.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: 10a146,7c58a4418eab2433
X-Google-Attributes: gid10a146,public
X-Google-Thread: 1073da,7c58a4418eab2433
X-Google-Attributes: gid1073da,public
X-Google-Thread: 107d46,7c58a4418eab2433
X-Google-Attributes: gid107d46,public
X-Google-ArrivalTime: 2002-07-09 11:19:59 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!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: Tue, 9 Jul 2002 20:16:22 +0200
Organization: oblomov.org
Message-ID: <20020709201622.064ab7ef.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>
 <3D2B2142.EC54B769@oracle.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: 22

Reply to Parent Message