I have a query that have a statment
Code:
... and SERVICE_CODE IN (?) ...
I need to pass dynamic params to that IN statement, and i tried to pass an Array of Strings, or a List<String> or even a String that I manually treated by shaping them like " 'code1', 'code2', 'code3' ".
It always fail and returns different kinds of SQL exceptions.
Any idea?
Note that I use external .SQL files.