Hi,
We are using Firebird 1.5.2 and have created stored procedures which
insert row copies with statements similar to:

insert t1 from select * from t1 where...

We have recently added new columns to this table t1, but have not
recompiled this stored procedure. We are now getting errors where
this statement fails.

When we recompile the stored procedure with an ALTER PROCEDURE call
the code works fine.

1) Can we force a recompile with a gbak switch (or similar db
maintenance operation)?

2) What are the risks of calling ALTER PROCEDURE on a database that is
currently open and in use?

Thanks, Mark