The input string must be as supported by the DB. If you’re using as you posted:
SELECT a, b, c
FROM [table]
WHERE [column] IN ?
then the string to pass in must be: (‘BB’,‘IV’)
Or for one: (‘BB’)
I would suggest you place the ( ) in the query itself.
SELECT a, b, c
FROM [table]
WHERE [column] IN (?)
Then the inputs would be ‘BB’,‘IV’ or ‘BB’
You cannot input a list var of any kind for the ? value. You need to create the comma-delimited string in a way that the DB accepts. Whatever the calling system is providing, you’ll need to form the string.
Post exactly what the adapter service inputs are and the SQL tab (don’t expose any confidential info). The community will be able to help determine what to do.
@Sandeep_Deepala is asking you to use another tool, such as SQL Developer or TOAD or any other client tool, for you to work out exactly the SQL query that will work. Then we can help put the same wiithin wM Integration Server (using Designer).
#webMethods-cloud#webMethods#Service-Designer#Integration-Server-and-ESB#webMethods-io-Integration