| Subject | RE: [firebird-support] Re: Block size exceeds implementation restriction exception for varchar(31000) |
|---|---|
| Author | Joje |
| Post date | 2016-09-08T12:33:35Z |
Thanx Jez.
I will have to modify the stored procedure.
Thank you once again.
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 08 September 2016 16:41
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Block size exceeds implementation restriction exception for varchar(31000)
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.
Jez