Re: refcursor for pipeline table function?

From: Richard Kuhler <noone_at_nowhere.com>
Date: Tue, 10 Jun 2003 22:06:10 GMT
Message-ID: <mDsFa.80026$x67.3598734@twister.socal.rr.com>

Jusung Yang wrote:
>
> Hmm... You sure? Can you show me the bugs? From this simple test, I
> did not see the problem you described. Here, using parallel enabled
> pipelined function, I want to transform data from 1 column based on
> the condition on another column. Namely

<snip>

The primary bug I was referring to is (BUG 2982476). Here's a demonstration ...

create or replace package pkg_pipeline_source as

type ttab is table of number;

function f_pipeline
return ttab
pipelined;

end pkg_pipeline_source;
/

Package created.

SQL> show errors
No errors.

SQL> alter package pkg_pipeline_source compile; alter package pkg_pipeline_source compile *
ERROR at line 1:
ORA-00600: internal error code, arguments: [17012], [0x2493199C], [], [], [],[], [], []

SQL> drop package pkg_pipeline_source;
drop package pkg_pipeline_source
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [4814], [5], [0], [0], [], [], [],[]

Richard Received on Tue Jun 10 2003 - 17:06:10 CDT