[python-sybase] stored procedure

[Potian, J. (Exchange) <jp...@be...>]

Hi listers,

I am trying to call a stored procedure using module v2.0 on Sybase version
11.9.2.  The problem is that not all the records I am querying for using the
stored procedure are returned in the result set.  Below is a snippet of my
code:

#
#Call stored procedure to get MO notification list(based on outage type)
#
db=Sybase.connect("<server>","<uname>","<pass>#",auto_commit=1)
c=db.cursor()
c.callproc('sp_get_mo_notification_list',tkt)
c.nextset()

r=c.fetchall()

print "NTFY LIST: " +str(r)

Is there anything else I should be doing in order to fetch all the records I
need?  Any help is greatly appreciated.

Regards,

Jon-Marcelius Potian
Bear Stearns & Co.
IT - Problem Management
Phone: 973-793-7053
Fax:     973-793-5775
Pager:  1-800-515-BEAR




**********************************************************************
Please be aware that, notwithstanding the fact that the person sending
this communication has an address in Bear Stearns' e-mail system, this
person is not an employee, agent or representative of Bear Stearns.
Accordingly, this person has no power or authority to represent, make
any recommendation, solicitation, offer or statements or disclose
information on behalf of or in any way bind Bear Stearns or any of its
affiliates.
**********************************************************************