Connection Error occurred selecting data: java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000

We found out that this is an Oracle SQL limitation. The IN statement in SQL only allows a max of 1000 values.

Is article helpful?