Using IN predicate in PL/SQL

In PL/SQL I have constructed a variable (called v_Pool) with the value ('ABC','DEF','GHI') to be used in the where clause of dynamic sql

The following code does not work...please help

if v_test IN v_Pool then
........;
end if;

Also how do I specify v_Pool in a cursor

cursor my_cur is
select *
from my_table
where myfield IN ???

Thanks Received on Thu Feb 28 2002 - 11:23:49 CST