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 wil
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:
> http://tracker.firebirdsql.org/browse/C
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 statemen
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 somethi