maximum number of items in a list

maximum number of items in a list

Post by Steve Raffer » Thu, 28 May 1998 04:00:00



I have written an application which finishes by passing
an SQL query to Oracle which looks like:

SELECT * FROM TABLE WHERE KEY IN (1,3,17,2023,50111 ...  )

When the number of items in the list exceeds some number
Oracle barfs and complains that the number of items is
greater than 254:

ORA-01795: maximum number of expressions in a list is 254

However, I have successfully retrieved lists of greater
than 900 items -- I suspect that the maximum number may
be more like 1000 (1024?) and that the 254 is legacy from
a previous version.

Does anyone know what the limit is exactly?

I'm running Oracle8.0.3 on Solaris 2.5.1.

TIA,

Steve