IN Lists
From: Mtek <mtek_at_mtekusa.com>
Date: Tue, 17 Feb 2009 11:47:09 -0800 (PST)
Message-ID: <ab2d2f54-720c-434b-8026-dc762976b3ee_at_e18g2000vbe.googlegroups.com>
Date: Tue, 17 Feb 2009 11:47:09 -0800 (PST)
Message-ID: <ab2d2f54-720c-434b-8026-dc762976b3ee_at_e18g2000vbe.googlegroups.com>
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...... Received on Tue Feb 17 2009 - 13:47:09 CST