Subject | Re: [ib-support] Invalid request BLR at offset 1951 |
---|---|
Author | Claudio Valderrama C. |
Post date | 2001-12-14T05:43:57Z |
""C Fraser"" <Colin.Fraser@...> wrote in message
news:000b01c1842b$6bbcccc0$8f01a8c0@COLINFRASER...
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
news:000b01c1842b$6bbcccc0$8f01a8c0@COLINFRASER...
> Hi,I thought that error was fixed before december 1999. A rule was relaxed to
>
> 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...
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