Re: IN Lists

From: Mtek <mtek_at_mtekusa.com>
Date: Tue, 17 Feb 2009 12:10:07 -0800 (PST)
Message-ID: <114cd9ff-f04a-4f5a-b354-0f7dfe0fe684_at_e6g2000vbe.googlegroups.com>

On Feb 17, 2:05 pm, ddf <orat..._at_msn.com> wrote:
> 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

Crap that is a lot of work to do this simple task.... Received on Tue Feb 17 2009 - 14:10:07 CST