[Zope-dev] ZSQL Methods from Python?

[Jim Fulton]

"Phillip J. Eby" wrote:
> 
> At 12:49 PM 9/22/00 -0400, Jim Fulton wrote:
> >"Phillip J. Eby" wrote:
> >>
> >> 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?
> >
> 
> By "return value", I mean the "return status" code which is an integer
> returned by the Sybase "RETURN" statement.  Sybase also can generate its
> own, negative-numbered return statuses, which indicate a Sybase error.
> These error codes can include ones that mean the current transaction has
> already been aborted.
> 
> Apart from the "return value", a Sybase stored procedure can execute
> SELECT's which result in rows being returned.  We have never used this
> capability, so I'm not sure what would need to be done for it to be
> practical.  We ordinarily use stored procedures only to perform inserts,
> updates, deletes, and other things that only need a integer result if
> anything.  (Eg: get next counter value to assign an object identifier.)

Ah, too bad. Can Sybase *only* return values through selected rows?

Oracle's stored procedures are much more like traditional procedures
and therefore extremely useful even when no results are returned.

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.