Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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?
>
> P.S. I noticed that the documentation of Oracle 9.2 describes the
> PIPELINED Clause at page 13-54 of the 'SQL Reference' for standalone
> funcions but not for functions inside packages ('PL/SQL User's Guide
> and Reference' page 13-93).
> But if pipelined table functions are not supported inside packages why
> my test_pkg works fine but ALTER PACKAGE not?
>
> Thanks.
Can't answer that question. And I'm certainly not going to defend Oracle documentation today. But if it says you can't ... don't. The solution is painless.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Fri Mar 12 2004 - 11:38:59 CST