Re: IN Lists
From: William Robertson <williamr2019_at_googlemail.com>
Date: Tue, 17 Feb 2009 22:54:26 -0800 (PST)
Message-ID: <9bdf064e-6ba7-4f72-be73-c99de925f81b_at_j38g2000yqa.googlegroups.com>
On Feb 17, 7: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.......
Date: Tue, 17 Feb 2009 22:54:26 -0800 (PST)
Message-ID: <9bdf064e-6ba7-4f72-be73-c99de925f81b_at_j38g2000yqa.googlegroups.com>
On Feb 17, 7: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.......
Try using collections and the MEMBER OF operator. http://www.williamrobertson.net/documents/comma-separated.html
> Oracle is being picky here......
Is there any programming language in which a comma-separated string works the way you just made up? Received on Wed Feb 18 2009 - 00:54:26 CST