Using multiple Dynamic Input Tools to run more than 1000 IN list values in a PL/SQL query

[nordmaeo]

I am attempting to run multiple dynamic input tools as a work around for PL/SQLs limit of 1000 IN list values in a SQL statement. My output has around 9000 list values that I am trying to pass through my query(I created a record ID and filter 1000 rows at a time into the Dynamic Input Tools), however filtering and using multiple dynamic input tools seems to freeze my workflow.

Is there a more efficient workaround for feeding more than 1000 IN list values through a SQL query?

Any help is much appreciated!

Thanks,

Eoin

[Ladarthure · Accepted solution]

Hi @nordmaeo,

what we do when we face this kind of problem is using the data-stream in and create a temporary table that we join afterwards with the "full database", you may have to ask your db admin to check if you can create a temporary table.

[nordmaeo]

Thanks! I was trying that earlier but I think I was joining on different data types, which was freezing the IN-DB join, or rather, the workflow stops at the data stream out tool. I'll give it another shot.