Unanswered: Passing a varchar value to an integer column
I want pre build query which I don't have access to change, to which I can pass a value which is varchar to an integer column.
where emp_id = '123, 124, 125';
I can convert the string to number using collections or some replace functions and pass it as a IN to the query. The problem is I can't change the "=" sign to "IN" as it is a pre-bulit query. Is there any way I can tweak the values before passing to the query.