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.
"Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message
> Can you use pipelined functions?
> There's a nice example in the app developers fundamentals guide (page 9-71).
> The end result is something like select * from TABLE(my_function(MyParameter)).
>
> Greetings!
> Volker
Received on Tue Mar 11 2003 - 19:36:11 CST
