Re: Pipelined table functions can be used inside a package?

lio.spam_at_libero.it wrote:
> Hi, I tried to use pipelined table functions inside a test package
> (the package code is at the end of the messagge).
>
> The package is created without errors and calling the table functions
> from a SQL statement like:
> SELECT * FROM TABLE(test_pkg.get_my_data2(1,'Numero: '))
> everything works fine.
>
> But if I try to recompile the package with:
> ALTER PACKAGE test_pkg COMPILE PACKAGE
> the session hangs up and I need to kill the session.
>
> Why this happens? There are some mistakes in the code?

<snip>

There are many bugs related to pipeline table functions still. I've filed at least 5 myself and I found another one last week. The one you are hitting is likely Bug No. 2982476.

--
Richard Kuhler