[python-sybase] Problem with calling stored procedures
Harri Pasanen
harri.pasanen at trema.com
Tue, 2 Apr 2002 12:07:47 +0200 (CEST)
Hello,
I think the old problem with calling some stored procedures still seems to be
there.
Namely, I still can't get any sensible results from calling sp_helpindex.
The code is something like:
def getindex(table):
print "getindex", table
c = cnx.cursor()
c.callproc("sp_helpindex", [table])
l = c.fetchall()
print l
while c.nextset():
l = c.fetchall()
print l
cnx=Sybase.connect("<server>","<uname>","<pass>")
cnx.cursor().execute("use mydb")
getindex("mytable")
-Harri