Subject | Implementation limit exceeded |
---|---|
Author | lele@seldati.it |
Post date | 2002-04-23T13:53:01Z |
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!
thanx&bye,
lele.
--
nickname: Lele Gaifax | Quando vivro' di quello che ho pensato ieri
real: Emanuele Gaifas | comincero' ad aver paura di chi mi copia.
email: lele@... | -- Fortunato Depero, 1929.
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!
thanx&bye,
lele.
--
nickname: Lele Gaifax | Quando vivro' di quello che ho pensato ieri
real: Emanuele Gaifas | comincero' ad aver paura di chi mi copia.
email: lele@... | -- Fortunato Depero, 1929.