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
> procedure SP_INVENTORY_UPDATE."

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
http://www.guacosoft.com