Firebird 2.5.2 classic server
I'm experiencing one problem when trying to recompile stored procedures.
Once I use one stored procedure from my application (that is not called
from triggers and other procedures), the only way to recompile the
procedure is to close user session.
I understand that one stored procedure can be recompiled if it is not used
but I have not read in any documentation that one stored procedure is in
use until closing the user session.
After using the stored procedure and close the form that uses it, freed the
applicacion object that calls the stored procedure and commit the
transaction, I don't see in mon$statements the stored procedure but if I
try to compile it I get the error "Object in use".
The curious is that I'm able to compile triggers.
Is this a bug? Need one Test case? Do I open a ticket?
Regards
------------------------------------------------------------------------------
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
