Error while compiling package with pipelined procedure

Vi'k

Member
I wrote the package:

create or replace package pltest
is

type my_type is record
(a varchar2(30),
b varchar2(30),
c varchar2(30));

type virtual_table_type is table of my_type;

function f(p_num_rows in number) return pltest.virtual_table_type pipelined;
end;

with this simple body:

create or replace package body pltest is

function f(p_num_rows in number) return pltest.virtual_table_type pipelined
is
cursor l_cur is
select A, B, C from T1 where p_num_rows > rownum;
l_row my_type;
begin
open l_cur;
loop
fetch l_cur into l_row.a, l_row.b, l_row.c;
exit when l_cur%notfound;
pipe row(l_row);
end loop;
close l_cur;
return;
end;

end;

Then I have opened for edit this package and body (by choosing "Edit Spec & Body") and pressed "Execute (F8)". And I got this:
ORA-00600: internal error code, arguments: [kokvxsql1],[],[],[],[],[],[],[]
ORA-00600: internal error code, arguments: [4814], [5],[0],[0],[],[],[],[]

Any ideas?

Oracle 9.2.0.1
PL/SQL Developer 6.0.3.893
 
Bug 2280512 OERI:KOKVXSQL1 OERI:4814 on CREATE OR REPLACE of package with PIPELINED function

Fixed:

This issue is fixed in

* 9.2.0.4 (Server Patch Set)
* 10g Production Base Release

Description

If a PIPELINED function is defined in a package with its return type
also defined as collection in the same package then if this package
then CREATE OR REPLACE of the package when it already exists results
in ORA-600 [KOKVXSQL1] / ORA-600 [4814] .
 
Back
Top