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

> > 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 Received on Tue Jul 09 2002 - 13:16:22 CDT