Re: IN Lists

From: ddf <oratune_at_msn.com>
Date: Tue, 17 Feb 2009 12:05:28 -0800 (PST)
Message-ID: <b2150da8-aaa1-4e40-a050-02ef5c7713af_at_v38g2000yqb.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......

You might want to read here:

http://oratips-ddf.blogspot.com/2008/09/how-dynamic.html

David Fitzjarrell Received on Tue Feb 17 2009 - 14:05:28 CST