18.08.2014 23:39, 'Carlos H. Cantu' wrote:
LSSBcfs While this would avoid the error, you will not know when/if your
change will be applied.
LSSBcfs A connection can hold an object in use for an indeterminant period
of time.
Dmitry said to me sometime ago that procedures changes will be
DYdusnfs It's not about when your DDL is applied but about the cached procedure
DYdusnfs BLR that is used by others. The changed (new) procedure BLR will be
used
DYdusnfs by newly compiled statements immediately after your DDL has been
DYdusnfs executed. However, all already compiled statements
Hello.
Sorry, but I didn´t, yet, understand why I can´t exceute an ALTER
PROCEDURE without _*closing all conections and restarting the FB
service.*__*
*_
I guess that the problem could be related to my application leaving some
transaction, that uses the SP, without commit/rollback or
19.08.2014 21:56, Hugo Eyng wrote:
Sorry, but I didn´t, yet, understand why I can´t exceute an ALTER
PROCEDURE without _*closing all conections and restarting the FB
service.*__*
You can.
I notice that i am not the only one facing this trouble: