iananewby wrote:

>
> The problem is that a number of stored procedures that were working
> have stopped working for an unknown reason. The only change is that
> the database has been recreated from a script.

Are you sure that the gds32 client matches the server? ie, that you
aren't mixing an old gds32, perhaps from InterBase with a new firebird
one, or vice versa?

> I've tried upgrading to 1.0.796 but am now getting an "Implemetation
> Limit Exceeded Block size exceeds implementation restriction" on all
> my stored procedures which call the udf's.
>
> When did this start to occur? My application which was working fine
> has now died a horrible death!

Ah, you should read the FAQ here: http://www.ibphoenix.com It explains
all. The problem has arisen because no check was made on expression
size. It was possible to crash the server because of this. There is now
a check and string expressions that evaluate to greater than 32k fail.

I'm not sure how this one is going to be resolved. String expressions
have to max out somewhere and 32k seems reasonable to me. The real
problem is that no check was ever made in the past, so more than a few
people have unknowingly taken advantage of this.


Paul
--

Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase