Using Oracle's "IN" function in JDBC Adapter Service

Has anyone used Oracle’s “IN” function in a webMethods JDBC Adapter Service? I need to query a table with a dynamic list of input on one column.

I have tried using a customSQL service with the where clause “supplier IN (?)”. This works fine if I send in one value, but does not work with multiple values, no matter how they are passed in or separated.

Try a dynamic SQL service. You can control the SQL in different ways with that.

I am using dynamic SQL template for using IN clause. It is working fine. Using dynamic SQL template you can pass any query to adapter.

You can solve with dynamin sql template.

You can use dynamic SQL template to use IN clause in SQL.

I tries using dynamic SQL template for using IN clause in SQL query. It is working fine.