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

postbus_at_sybrandb.demon.nl (Sybrand Bakker) wrote in message news:<a20d28ee.0203010648.6d409555_at_posting.google.com>...
> 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 ASTab)) 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

to Sysbrand Bakker:
  can you give me more detail information? thanks Received on Sat Mar 02 2002 - 10:12:23 CET