Pass quotes and commas to & parms in PL/SQL?

  I want to set up a generic prog PROGRAMX that includes

  SELECT BLAH, BLAH, BLAH
  WHERE SOMETHING IN (&1); I'd like to pass a quoted string like...  'foo','bar'
as one string. PL/SQL chokes on this. I've tried escaping with backslashes, etc. Nothing seems to work beyond one parm. With SET VERIFY ON, I've confirmed that...   @PROGRAMX '''string'''
resolves to...
  SELECT BLAH, BLAH, BLAH
  WHERE SOMETHING IN ('string');

No luck with additional quotes and commas in the &1 parameter.

--
Walter Dnes <waltdnes_at_interlog.com> procmail spamfilter http://www.interlog.com/~waltdnes/spamdunk/spamdunk.htm Why a fiscal conservative opposes Toronto 2008 OWE-lympics http://www.interlog.com/~waltdnes/owe-lympics/owe-lympics.htm Received on Fri Jul 02 1999 - 00:53:43 CDT