Re: IN Lists
From: Mtek <mtek_at_mtekusa.com>
Date: Tue, 17 Feb 2009 12:02:19 -0800 (PST)
Message-ID: <90753d44-d9eb-46aa-8149-6acb5806314f_at_m16g2000vbp.googlegroups.com>
On Feb 17, 1:47 pm, Mtek <m..._at_mtekusa.com> wrote:
> Sheesh, how hard can this be:
>
> IF p_code IN v_code_list THEN
> v_query := v_query || ' AND p_code IN v_code_list';
> END IF;
>
> Does not like that. The IN list will be dynamic.......
>
> Oracle is being picky here......
20/16 PLS-00103: Encountered the symbol "V_CODE_LIST" when expecting
Date: Tue, 17 Feb 2009 12:02:19 -0800 (PST)
Message-ID: <90753d44-d9eb-46aa-8149-6acb5806314f_at_m16g2000vbp.googlegroups.com>
On Feb 17, 1:47 pm, Mtek <m..._at_mtekusa.com> wrote:
> Sheesh, how hard can this be:
>
> IF p_code IN v_code_list THEN
> v_query := v_query || ' AND p_code IN v_code_list';
> END IF;
>
> Does not like that. The IN list will be dynamic.......
>
> Oracle is being picky here......
More research: It gives error on - IF p_code IN v_code_list THEN
LINE/COL ERROR
20/16 PLS-00103: Encountered the symbol "V_CODE_LIST" when expecting
one of the following:
Ho hum..... Received on Tue Feb 17 2009 - 14:02:19 CST