# Too many values in an IN list / too many parameters (limit exceeded)

**Code:** `IN list` · **Category:** SQL · **Seen on:** SQL, SQL Server, Oracle, SQLite

A huge `IN (...)` list or too many bound parameters exceeds a database limit.

## Meaning

Limits differ: SQL Server 2100 parameters, SQLite 32766 (older 999), Oracle 1000 items per IN list, PostgreSQL 65535 parameters, MySQL `max_allowed_packet`. Batch the values, load them into a temp table or table-valued parameter and join, or use `= ANY(array)` in PostgreSQL.

## Common causes

- ORM generating a giant IN list
- Bulk fetch by many IDs
- Exceeding parameter count limit
- Query text larger than `max_allowed_packet`
- Oracle's 1000-item IN limit

## Quick fix

1. Batch IDs into chunks of 500-1000
2. Use a temp table/table-valued parameter and JOIN
3. PostgreSQL: `WHERE id = ANY($1)`

## Detailed fix by platform

### SQL

1. `SELECT * FROM orders WHERE id = ANY($1::bigint[]);`

## How to diagnose

1. **List size** — Over the limit?
2. **Alternative** — Temp table/array?
3. **Driver** — Binds each value?

---
Source: [WhatIsMyError](https://whatismyerror.com/errors/sql/in-list-too-many-parameters)
