PL/SQL Help! Using Variable String as Argument in "where in" clause

Please email any responses to als_at_akc.org

Thank you in advance for your help

I'm trying to use a variable defined as a string of values in a SQL select statement. So far, defining a variable as a string of values works when I run the SQL but doesn't select anything when I try to execute the same statement as part of a PL/SQL procedure's cursor. Any tips?

Example:
IF some_condition = 1 then

       v_string := '''A'',''B'',''C'''; ELSIF some_condition = 2 then

       v_string := '''D'',''E'',''F'''; ELSE v_string := '''G'',''H'',''I''';
END IF; Select 'x'
from my_table
where my_field in (v_string); Received on Mon May 18 1998 - 21:21:08 CDT