Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: View with a parameter
"Jusung Yang" <JusungYang_at_yahoo.com> wrote in message news:130ba93a.0303111736.5cef9672_at_posting.google.com...
> Yes. This is another alternative. Actually, there is a thread at Tom
> Kyte's website that discussed this issue (search for parameterized
> view), in which Tom suggested using a procedure that returns a
> refcursor. You can not put a procedure in the FROM clause like you can
> with a pipelined function. So you have to wrap it in an anonamouns
> block. But, according to the thread, the refcursor approach can be 8 -
> 10 times fatser than the pipelied function approach.
Ok, thanks!
Volker
Received on Wed Mar 12 2003 - 03:03:35 CST