Subject Re: [firebird-support] Alter a procedure corrupts the database
Author Milan Babuskov
kokok_kokok wrote:
> I have a stored procedure without any return variable, then I alter
> the procedure adding an output variable. I do a backup without
> problems, but when I restore the database, I get
> "Invalid request BLR at offset 163. Output parameter mismatch for

This is a known issue in FB and is registered in the tracker.

> Before altering the SP, I could do backups and restores without
> problems. I am using Firebird 2.0.
> Have somebody a clue about how to solve it?

Use FlameRobin. It detects this kind of situation when you alter the
procedure and tells you which objects you need to update.

Milan Babuskov