Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Package or Function LIST is In INvalid State

Re: Package or Function LIST is In INvalid State

From: mike <hillmw_at_charter.net>
Date: 11 Mar 2005 13:34:03 -0800
Message-ID: <1110576843.314542.223560@o13g2000cwo.googlegroups.com>


OK, Here it is:

name type line text
LIST FUNCTION 1 function list ( field1 number ) LIST FUNCTION 2 return varchar2 as
LIST FUNCTION 3 res varchar2(2000) := null; LIST FUNCTION 4 first boolean := true;
LIST FUNCTION 5 begin
LIST FUNCTION 6 for curs in
LIST FUNCTION 7 (select struct_id from li_bene_orgs where leanit_num=field1 order by struct_id )
LIST FUNCTION 8 loop
LIST FUNCTION 9 if not first then
LIST FUNCTION 10 res := res || ', ';
LIST FUNCTION 11 else
LIST FUNCTION 12 first := false;
LIST FUNCTION 13 end if;
LIST FUNCTION 14 res := res || curs.struct_id; LIST FUNCTION 15 end loop;
LIST FUNCTION 16 return res;
LIST FUNCTION 17 end list;
LIST FUNCTION 18 select leanit_num, list(leanit_num) LIST FUNCTION 19 from li_bene_orgs
LIST FUNCTION 20 group by leanit_num

name type sequence line position text
LIST FUNCTION 1 18 1 PLS-00103: Encountered the symbol "SELECT" LIST FUNCTION 2 20 19 PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: . ( ) , * @ % & - + / at mod rem with group having intersect minus start union where connect ||

Thanks for your patience .... Never done functions b-4.

Mike Received on Fri Mar 11 2005 - 15:34:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US