what's wrong with this pl/sql block?
From: techhelp <totemp_at_sohu.com>
Date: 1 Mar 2002 02:28:30 -0800
Message-ID: <6ba31ecd.0203010228.13aa176d_at_posting.google.com>
end;
--following is result when exec this block declare
*
ERROR 位于第 1 行: ORA-00600: internal error code, arguments: [15419], [severe error during PL/SQL
execution], [], [], [], [], [], [] ORA-06544: PL/SQL: internal error, arguments: [pfrrun.c:pfrbnd1()], [], [], [],
[], [], [], []
ORA-06553: PLS-801: internal error [0] Received on Fri Mar 01 2002 - 11:28:30 CET
Date: 1 Mar 2002 02:28:30 -0800
Message-ID: <6ba31ecd.0203010228.13aa176d_at_posting.google.com>
declare
type newStruct is record( c1 number, c2 number ); type NTab is table of newStruct; type Cursortype is ref cursor; nList NTab:=NTab(); myCursor Cursortype;
begin
nList.extend;
nList(1).c1:=1;
nList(1).c2:=2;
nList.extend;
nList(2).c1:=11;
nList(2).c2:=22;
dbms_output.put_line(nList(1).c1);
dbms_output.put_line(nList(1).c2);
dbms_output.put_line(nList(2).c1);
dbms_output.put_line(nList(2).c2);
--error at this line
open myCursor for SELECT t.* FROM TABLE(nList) t ;
--open myCursor for SELECT * FROM TABLE(CAST(nList AS
NTab)) t ;
end;
--following is result when exec this block declare
*
ERROR 位于第 1 行: ORA-00600: internal error code, arguments: [15419], [severe error during PL/SQL
execution], [], [], [], [], [], [] ORA-06544: PL/SQL: internal error, arguments: [pfrrun.c:pfrbnd1()], [], [], [],
[], [], [], []
ORA-06553: PLS-801: internal error [0] Received on Fri Mar 01 2002 - 11:28:30 CET