Subject RE: [firebird-support] Firebird Crashes creating strored procedures dynamicly ?
Author Leyne, Sean
Ryan,

> We contniue have have problems with firebird server crashing -
seemingly
> as a result of dynamicly creating stored procedures and attemptng to
use
> these on other connections.

Are you creating the SP, committing, and then executing the SP?

(note the commit between the create and run/execute)


Are you ensuring that each client is calling an SP which is unique for
it's use? I.e. How are you ensuring that Client B is not trying to
change the SP which Client A created and is running? (Unique naming
convention?)


Sean