How to pass comma separated value in bind variable of VOquery?
900578Sep 18 2012 — edited Sep 19 2012Version 11.1.1.3.0
Guys need you help on this
I have a VO with query somethg like below
SELECT *
FROM schema.Table_name
WHERE (:Bind_Varible is null or Column_Name IN( :Bind_Varible))
User will be selecting more than one value from Screen and i need to pass those value in above bind variable.
But in ADF bind variable take everything as a single string, so how can i pass the comma separated values?
Like SELECT *
FROM schema.Table_name
WHERE (:Bind_Varible is null or Column_Name IN(99,55))
Thanks
Any help will be appreciated