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

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 27 Jan 2003 05:57:54 -0800
Message-ID: <1efdad5b.0301270557.57a0b694@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 - 07:57:54 CST