Re: Is it possible to use bind variables with an 'IN'

Oops, forgot in my previous post to include this type creation statement:

create type typ_tab_v2100 as table of varchar2(100); /

• Jusung Yang

rgaffuri_at_cox.net (Ryan Gaffuri) wrote in message news:<1efdad5b.0301270557.57a0b694_at_posting.google.com>...
> the first part is simply looping through a PL/SQL table and building a
> comma-delimited string of files I want to use in my 'IN' statement.
>
>
> FOR i IN l_resourceID.FIRST.. l_resourceID.LAST
> LOOP
> IF v_resourceidString IS NOT NULL
> THEN
> v_resourceidString := v_resourceidstring
> ||','||to_char(l_resourceID(i).RESOURCE_ID);
> (i).RESOURCE_SEQ);
> ELSE v_resourceidString := l_resourceID(i).RESOURCE_ID;
>
> END IF;
> -----------------------------------------------------------------
> Oracle cant parse what is below.
> EXECUTE IMMEDIATE 'DELETE FROM RD_ASSOC_CONTAINER_TEST'||
> 'WHERE RESOURCE_ID IN (:1)'
>
> using v_resourceidString;
>
> Oracle cant parse this properly. Is there a way to do this with bind
> variables? I have done this before when I had to get a list of column
> names to search and put them in the 'SELECT' clause without bind
> variables?
Received on Mon Jan 27 2003 - 16:03:29 CST