Re: refcursor for pipeline table function?

Jusung Yang wrote:
>
> Use SQL collection type for your pipelined function return type, it
> will work. SQL types seem to have fewer problems/restrictions. For a
> non-pipelined table function, you will not be able to get data out of
> it from SQL, since you need to type cast the table function. You can
> not use type in a package for type casting.

That's a good part of why we are switching and the reason for my original question. The solution you showed has a major drawback in that you've duplicated the entire declaration of your object to make your record. I'm sure you've looked at the far more maintainable solution I already posted in this thread.

Thanks,
Richard Received on Wed Jun 11 2003 - 01:40:41 CDT