[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