At 03:53 PM 23-04-02 +0200, you wrote:

>Hi there,
>
>I'm getting this error
>
> Implementation limit exceeded
> block size exceeds implementation restriction
>
>trying to execute a script that alter several SPs. This happens only
>on FB1.0. I tried to isolate the problem, but it does not seem to be
>easily reproducible, as sometime the very same script executes
>ok. The usual workaround till now was splitting the script into single
>ALTER PROC statements, but yesterday it happened also with a single
>proc! worst, the same little script ran ok on another box, with
>1.0/Linux.... (there no need to say which OS is running where the
>script fails..., as in *this* case it seems accidental :/)
>
>As somebody already said (Claudio, I searched !-), this may be related
>to a rc2->1.0 change that in some way fixed at 32k the max length of a
>string, but there's nothing evident in my code that should hit that
>limit... even if the script as a whole may be bigger than that, surely
>there is no a single SPs that get even close to that.
>
>This is tricking me, any help will be appreciated!

Lele,
Do you happen to have any DML in there that is using the IN()
predicate? The implementation limit for that is 1500 maximum items in the
set. Maybe you are seeing it succeeding on smaller sets and falling over
on sets > 1500...

Helen


All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________