Help - Using parameters in SELECT statements
From: Shari Fletcher <sfletcher_at_terrace.com>
Date: 1997/02/11
Message-ID: <01bc1870$1abb0840$ca0769cf_at_sfletcher.terrace.com>#1/1
Date: 1997/02/11
Message-ID: <01bc1870$1abb0840$ca0769cf_at_sfletcher.terrace.com>#1/1
Am trying to compare a numeric value against a list of values to in a SQL
Statement in a PL/SQL stored procedure using IN. Am using SQL Windows as a
front end and submitting the values as a comma-delimited string (i.e.
'3,4,5') but cannot do because PL/SQL will literally translate this in the
where clause and compare its numeric key as follows:
WHERE excpt_ID IN ('3,4,5')
Cannot send the parameter from SQL Windows without the single quotes
because it will treat the values as additional parameters. also, for some
reason, stripping out the single quotes did not work ---
thanks in advance for any help
s.fletcher