Re: what's wrong with this pl/sql block?

totemp_at_sohu.com (techhelp) wrote in message news:<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 &#20301;&#20110;&#31532; 1 &#34892;:
> 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]

Please check the syntax of OPEN <ref cursor> FOR preferably before posting

Regards

Sybrand Bakker
Senior Oracle DBA Received on Fri Mar 01 2002 - 15:48:26 CET