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
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