Re: [python-sybase] Sybase Module 0.36 Output Parameter Handling

[Skip M. <sk...@po...>]

    Bradley> For example:

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

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

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

I think it's returned by a subsequent call to C.fetchall().  A stored
procedure can return the result of multiple selects so you need to keep
asking the cursor if there are more result sets and call fetchall() as long
as there are:

        while True:
           rows = C.fetchall()
           print rows
           if not C.nextset():
               break

    Bradley> Finally, what does the "1" in Sybase.OUTPUT(1) mean?  

I don't recall.  Someone else will have to chime in.

Skip