I ported some SQL over from Toad for Oracle into Data Point. The IN statement in question is
…AND COUNTY_CD IN (&COUNTY_CD)
In TFO, passing &COUNTY_CD (varchar) as a comma separated list of values (‘01’,‘02’,‘03’ ) etc. worked fine.
In TDP, …AND COUNTY_CD IN (:COUNTY_CD) returns nothing for (‘01’,‘02’,‘03’). It will, however, return data for one input (‘01’) only. This also works …IN (:COUNTY_CD1, :COUNTY_CD2) etc. with one value for each parameter.
The problem is, the number of items passed can vary greatly, so I wondering why I can’t pass a list of values in TDP like I used to. It’s gonna force me to make major changes in my SQL if I can’t.
FYI, these are scripts in Toad Data Report files, not database step-by-step lines. I use TDP 3.30, Oracle 13.0.