Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Pipelined table functions can be used inside a package?

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

From: Richard Kuhler <noone_at_nowhere.com>
Date: Fri, 12 Mar 2004 20:54:26 GMT
Message-ID: <6sp4c.24487$Zo6.1016@twister.socal.rr.com>


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
Received on Fri Mar 12 2004 - 14:54:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US