Re: Suited procedure return value?

--14dae9340a1b5bdbb104f47e2a55
Content-Type: text/plain; charset=UTF-8

> Given this simple stored procedure:
>
> create stored procedure test_proc
> as
>     return 1
>
> Is there a way in 0.40pre2 to get the return value?

I believe I have this figured out. There is a bug in the handling of
the status result. Unlike 0.38 and earlier, the return value of the
stored procedure is processed. Unfortunately, it's saved to a local
variable instead of in an attribute of the Cursor object. I've
attached a proposed patch.

The user here who was stung by this thinks it's the proper fix.
Hopefully someone is reading this (Rob?, Sebastien? Andrew? Dave?) and
can comment on its accuracy.

Skip

--14dae9340a1b5bdbb104f47e2a55
Content-Type: text/plain; charset=US-ASCII; name="pysy.diff"
Content-Disposition: attachment; filename="pysy.diff"
Content-Transfer-Encoding: base64
X-Attachment-Id: f_hsq5nyee0

KioqIC9ob21lL3NraXBtLzNyZFBhcnR5L3B5dGhvbi1zeWJhc2UtMC40MHByZTIvU3liYXNlLnB5
Ln4xfglXZWQgRGVjICA3IDE2OjQ0OjA2IDIwMTEKLS0tIC9ob21lL3NraXBtLzNyZFBhcnR5L3B5
dGhvbi1zeWJhc2UtMC40MHByZTIvU3liYXNlLnB5CVRodSBNYXIgMTMgMDk6MjM6NTcgMjAxNAoq
KioqKioqKioqKioqKioKKioqIDMzNCwzMzkgKioqKgotLS0gMzM0LDM0MCAtLS0tCiAgICAgICAg
ICBzZWxmLmlucHV0bWFwID0gaW5wdXRtYXAKICAgICAgICAgIHNlbGYub3V0cHV0bWFwID0gb3V0
cHV0bWFwCiAgICAgICAgICBzZWxmLmFycmF5c2l6ZSA9IDEgICAgICAgICAgICAgICMgREItQVBJ
CisgICAgICAgICBzZWxmLnN0YXR1c19yZXN1bHQgPSBbXQogICAgICAgICAgc2VsZi5fY3RfY3Vy
c29yID0gRmFsc2UKICAgICAgICAgIHNlbGYuX2ZldGNoaW5nID0gRmFsc2UKICAgICAgICAgIHNl
bGYuX3Jlc2V0KCkKKioqKioqKioqKioqKioqCioqKiAzODYsMzk0ICoqKioKICAgICAgICAgICAg
ICAgICAgc3RhdHVzID0gc2VsZi5fY21kLmN0X2NhbmNlbChDU19DQU5DRUxfQ1VSUkVOVCkKICAg
ICAgICAgICAgICBlbGlmIHJlc3VsdCA9PSBDU19TVEFUVVNfUkVTVUxUOgogICAgICAgICAgICAg
ICAgICBfYnVmcyA9IHNlbGYuX3Jvd19iaW5kKDEpCiEgICAgICAgICAgICAgICAgIHN0YXR1c19y
ZXN1bHQgPSBbXQohICAgICAgICAgICAgICAgICB3aGlsZSBzZWxmLl9mZXRjaF9yb3dzKF9idWZz
LCBzdGF0dXNfcmVzdWx0KToKISAgICAgICAgICAgICAgICAgICAgIHBhc3MKCiAgICAgIGRlZiBj
YWxscHJvYyhzZWxmLCBuYW1lLCBwYXJhbXMgPSAoKSk6CiAgICAgICAgICAnJydEQi1BUEkgQ3Vy
c29yLmNhbGxwcm9jKCkKLS0tIDM4NywzOTMgLS0tLQogICAgICAgICAgICAgICAgICBzdGF0dXMg
PSBzZWxmLl9jbWQuY3RfY2FuY2VsKENTX0NBTkNFTF9DVVJSRU5UKQogICAgICAgICAgICAgIGVs
aWYgcmVzdWx0ID09IENTX1NUQVRVU19SRVNVTFQ6CiAgICAgICAgICAgICAgICAgIF9idWZzID0g
c2VsZi5fcm93X2JpbmQoMSkKISAgICAgICAgICAgICAgICAgc2VsZi5fZmV0Y2hfc3RhdHVzKCkK
CiAgICAgIGRlZiBjYWxscHJvYyhzZWxmLCBuYW1lLCBwYXJhbXMgPSAoKSk6CiAgICAgICAgICAn
JydEQi1BUEkgQ3Vyc29yLmNhbGxwcm9jKCkKKioqKioqKioqKioqKioqCioqKiA5NTYsOTY2ICoq
KioKICAgICAgICAgIHNlbGYuX3Jlc3VsdF9saXN0ICs9IGxvZ2ljYWxfcmVzdWx0CgogICAgICBk
ZWYgX3N0YXR1c19yZXN1bHQoc2VsZik6CiEgICAgICAgICBzdGF0dXNfcmVzdWx0ID0gW10KISAg
ICAgICAgIHdoaWxlIHNlbGYuX2ZldGNoX3Jvd3Moc2VsZi5fYnVmcywgc3RhdHVzX3Jlc3VsdCk6
CiEgICAgICAgICAgICAgcGFzcwogICAgICAgICAgc2VsZi5fbWFpbmxvb3AoKQoKCiAgY2xhc3Mg
Q29ubmVjdGlvbjoKCi0tLSA5NTUsOTY3IC0tLS0KICAgICAgICAgIHNlbGYuX3Jlc3VsdF9saXN0
ICs9IGxvZ2ljYWxfcmVzdWx0CgogICAgICBkZWYgX3N0YXR1c19yZXN1bHQoc2VsZik6CiEgICAg
ICAgICBzZWxmLl9mZXRjaF9zdGF0dXMoKQogICAgICAgICAgc2VsZi5fbWFpbmxvb3AoKQoKKyAg
ICAgZGVmIF9mZXRjaF9zdGF0dXMoc2VsZik6CisgICAgICAgICBzZWxmLnN0YXR1c19yZXN1bHQg
PSBbXQorICAgICAgICAgd2hpbGUgc2VsZi5fZmV0Y2hfcm93cyhzZWxmLl9idWZzLCBzZWxmLnN0
YXR1c19yZXN1bHQpOgorICAgICAgICAgICAgIHBhc3MKCiAgY2xhc3MgQ29ubmVjdGlvbjoK
--14dae9340a1b5bdbb104f47e2a55
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
--14dae9340a1b5bdbb104f47e2a55
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Python-sybase-misc mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/python-sybase-misc

--14dae9340a1b5bdbb104f47e2a55--