Any size limit on IN-LIST in a SQL

Is there any limit on how long the parameters can grow in IN list of select statement. We have values in Java array, and want to use those values in sql statements' IN Clause.

select col1
from tab1
where col1 IN ( value1, value2, ....size limit?);

Thanks,
MK Received on Tue Nov 28 2000 - 17:21:16 CST