RE: Sybase stored procs question

Grant McDonald <[email protected]> Fri, 7 Apr 2006 10:00:30 +1000
Newsgroups gmane.comp.python.sybase
Message-ID <61DA7719C45FD31185280008C733EF6E06F3EFED@XCHANGE>
Mike,

Firstly may I point you to the documentation?:

http://www.object-craft.com.au/projects/sybase/sybase/

It should answer most of your questions. Secondly, on the cursor object is a
method named nextset() this is what you want. The documentation contains a
full description of what this method does.

Grant

-----Original Message-----
From: [email protected]
[mailto:[email protected]]On Behalf Of mike
Sent: Thursday, April 06, 2006 7:21 PM
To: Python Sybase
Subject: [python-sybase] Sybase stored procs question


hi

I have a Sybase stored proc  that was coded such that it returns a
number of "select" statements to the caller.

eg
select 'Begin Processing...'
...
select 'Transaction finished'


I have tried to call this procedures using execute or callproc
methods, but was only able to return the first result ie 'Begin
Processing' , using fetchall. How can i catch all "select" outputs..
thanks
_______________________________________________
Python-sybase mailing list
[email protected]
https://www.object-craft.com.au/cgi-bin/mailman/listinfo/python-sybase

_______________________________________________
Python-sybase mailing list
[email protected]
https://www.object-craft.com.au/cgi-bin/mailman/listinfo/python-sybase