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. Dmitry ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org 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 http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/