The number of in parameters in Oracle is limited

Encountered this problem "in the number of parameters in Oracle Limit", which is recorded here,

There is a limit to the number of arguments in the parentheses, and the number of Oracle 9i cannot exceed 1000 256,oracle 10g.

When the number of in is greater than 1000, the solution is:

(1) The parameter is processed, divided into multiple in, where the parameters in each in list are less than 1000, such as in (1,2,3.........1000) or params in (1001,1002...2000).

However, the performance and maintainability of this method is not good

(2) is to change the string in the back to a subquery, save the data in the in the temporary table, the params in (select .... from dual)

The number of in parameters in Oracle is limited