Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Package or Function LIST is In INvalid State
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