Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Select Function Returning Results of Select on Tables
"Burt Peltier" <burttemp1ReMoVeThIs_at_bellsouth.net> wrote in message
news:Lqseb.6140$Nz6.1957_at_bignews4.bellsouth.net...
> I did search Google before this. I don't see any example that does what I
> would like to do. I saw some things that are close.
>
> I would like to create a function that I can select which does some
> processing to create a global temporary table and then returns a select on
> the global temporary table.
>
> I am running Oracle 8.1.7.4 on Solaris 8 .
>
> --
>
>
Do you really really need a global temporary table? You would use a stored
procedure and a refcursor as an out parameter. You should try just
returning the query directly in the refcursor. It will probably be faster.
Jim
Received on Tue Sep 30 2003 - 23:30:15 CDT