Re: Package or Function LIST is In INvalid State

On Fri, 11 Mar 2005 13:34:03 -0800, mike wrote:

> OK, Here it is:
>

 snip ...
> 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

You have included the

        SELECT LEANIT_NUM, LIST( ...) as part of the source code for the function. I'm reasonably sure that you meant to terminate the function before that select statement. In SQL Plus that termination is created by a / (slash) on a line by itself. Received on Fri Mar 11 2005 - 15:44:48 CST