Is it possible to perform a multi-row delete using the ‘in’ operator over CustomSQL in the JDBC adapter? (Oracle db)
I tried the following steps
DELETE FROM Table1 WHERE Col1 IN ( ? )
Input for Adapter:
VARCHAR, java.lang.String, col_in
When running, set col_in to
No records were deleted.
When i set col_in to just 1004, without any quotes, the delete succeeded. Is there a way to concatenate and pass a list of values to the the in clause of a delete statement?
Thanks for your help,