Sybase Module 0.36 Output Parameter Handling

"Bradley Feldman" <[email protected]> Wed, 16 Mar 2005 13:21:27 -0800
Newsgroups gmane.comp.python.sybase
Message-ID <!~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAAl26AvnJDdE2pAhSiEiAYTsKAAAAQAAAAoVepKYuCqUmSci5Y4BHsMgEAAAAA@bradleyloritheo.com>
I have a question about the handling of Output Parms which is a new feature
of 0.36.  I understand how to pass the output parm syntax to the database
within the callproc as given in the release notes, but how to I see the
value passed back?  This seems simple, but there is no example of evaluating
the resulting parameter and I can't seem to figure it out.

For example:

C.callproc ('testproc', {'@parm1': 'value1', '@outputparm':
Sybase.OUTPUT(1)})

If I print the callproc object after it executes I get back something like:
{'@parm1':'value1','@outputparm': <DataBufType object at 0x2a394999>}

So how to I examine the contents of the DataBufType object, using python db
api syntax?

Finally, what does the "1" in Sybase.OUTPUT(1) mean?   A buffer size of 1
byte?  A value of 1 contained in one byte?  Can I simply pass a variable
reference instead, such as Sybase.OUTPUT(thisVar)?

Thanks so much for your help, in advance.

*Bradley