Subject Re: [firebird-support] Re: object is in use
Author Hugo Eyng

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 something so. But I am not sure.

Win 2008 R2 enterprise 64bits
Dell PowerEdge R620
32gb RAM
FB 2.5.2

I notice that i am not the only one facing this trouble:

Using and WAIT or NO WAIT Transaction, in my opinion, is not the answer, or at least no the best answer.

I tried to find 'who' or 'what' is using the STORED PROCEDURE while I am trying to excecute the ALTER, but I was
not able to do it.


Em 19/08/2014 06:03, Dmitry Yemanov dimitr@... [firebird-support] escreveu:
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
executed immediately and not get held. I tested and seems to be true
(ie: "wait" behavior is different for such case).
It's not about when your DDL is applied but about the cached procedure 
BLR that is used by others. The changed (new) procedure BLR will be used 
by newly compiled statements immediately after your DDL has been 
executed. However, all already compiled statements will keep using the 
old procedure BLR until these statements are released.

So Sean is correct except that "holding an object" applies to particular 
statements, not a connection as a whole.





Visit and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at 


Yahoo Groups Links

<*> To visit your group on the web, go to:

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    (Yahoo! ID required)

<*> To change settings via email:

<*> To unsubscribe from this group, send an email to:

<*> Your use of Yahoo Groups is subject to:



Hugo Eyng