Hello Colin

> I have just edited a stored procedure (about 10 minutes ago) and it
> clearly is not being used yet.
>
> I can disconnect from the db, go back into it and verify that the stored
> procedure code has been updated, but the actions being performed by
> other applications when executing the stored procedure clearly show that
> old version of the stored procedure is being executed.
>
> First question is, is this normal? Something to-do with transactions
> perhaps?

Yes it is normal, because BLR of stored procedures is cached for all
other connections.

> And the next question is how do I get my new stored procedure to be
> used?

The other clients must reconnect to see the compiled changes of the
stored procedure.


Regards,
Thomas Steinmaurer
IB LogManager 2.1 - The Logging/Auditing Tool for InterBase and Firebird
http://www.iblogmanager.com