Subject Re: [ib-support] Invalid request BLR at offset 1951
Author Claudio Valderrama C.
""C Fraser"" <Colin.Fraser@...> wrote in message
news:000b01c1842b$6bbcccc0$8f01a8c0@COLINFRASER...
> Hi,
>
> We are getting an error with our development database as follows:
>
> Invalid token
> invalid request BLR at offset 1951.
> parameter mismatch for procedure <a_procedure_name>
>
> Changes will be rolled back...

I thought that error was fixed before december 1999. A rule was relaxed to
allow invalid procs to be dropped.
Have you tried to alter the procedure to set a blank body? For example
set term ^;
alter procedure p as begin exit; end
set term ;^

If this doesn't work, you may try to create a new procedure with such body,
then replace the offending proc's BLR with the dummy proc's BLR.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing