At 01:50 PM 10/1/01 +0200, Thomas_Janke@prisma-edv.de wrote:

Does anybody know of any development going on regarding Sybase and stored procedures? Christopher Petrilli declared them a future goal, but I urgently need them by now. So if anybody has a workarround, please let me know.

Ty did some work on this for Zope 2.2 which you can find at: http://cvs.eby-sarna.com/ZProducts/SybaseStoredProcedure/ There's no docs to speak of. Feel free to use it if you can get it to work. I think that to get this to work, we also had to patch the Sybase DA to handle status result codes, but that patch might have been incorporated into Zope. I'm not positive about any of this. :( All I can tell you is that the code above is in actual use in a production application that needed stored-procedure support. Note that it does not support returning SELECT results from procedures; only non-negative status returns. It assumes a negative status is an error, and if it's one of the standard Sybase status error codes (e.g. -3 for a deadlock), it throws a "SybaseProcError" with an explanation and the original query text. The return value from calling a StoredProcedure object is always an integer 0 or greater, unless the status return is negative, in which case an exception is raised.