Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Is it possible to use bind variables with an 'IN'
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.
'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