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

, ,
1

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.

2

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

3

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.

4

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.