[Zope-dev] ZSQL Methods from Python?

Jim Fulton jim@digicool.com
Fri, 22 Sep 2000 12:49:06 -0400


"Phillip J. Eby" wrote:
> 
> At 08:43 AM 9/22/00 -0400, Jim Fulton wrote:
> >> Also, does anyone know of any work done to extend ZSQL Methods to allow
> >> stored-procedure calls?
> >
> >No, but I'd love to see someone tackle it. The semantics
> >of stored procedures varies so widely accross databases, that
> >I doubt that it would be easiliy generalizable. I think, at
> >least for starters, a form of stored procedure support for
> >Oracle would make alot of sense.
> >
> 
> Ty and I have put together a Stored Procedure method for Sybase; it
> requires a minor patch to ZSybaseDA, however, to allow for the status code
> return.  I'm not sure how useful it would be to anyone else, though, since
> all we ever do with stored procedures is process the return value, and
> ignore any actual SELECT results.

I think it would be useful. Can you get multiple return values?

Jim

--
Jim Fulton           mailto:jim@digicool.com   Python Powered!        
Technical Director   (888) 344-4332            http://www.python.org  
Digital Creations    http://www.digicool.com   http://www.zope.org    

Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email
address may not be added to any commercial mail list with out my
permission.  Violation of my privacy with advertising or SPAM will
result in a suit for a MINIMUM of $500 damages/incident, $1500 for
repeats.