Subject Re: Block size exceeds implementation restriction exception for varchar(31000)
Author Jeremy Poppleton

Firebird has limitation on both IN clauses and parameter lists for stored procedures.

Going down the route of trying to get around this can then cause errors with the command text limit.


It is always best to redesign your stored procedure or query to join on a table that has the particular parameters or ID stored. This is also much faster.