search

baztian / jaydebeapi

JayDeBeApi module allows you to connect from Python code to databases using Java JDBC. It provides a Python DB-API v2.0 to that database.
GNU Lesser General Public License v3.0
364 stars 147 forks source link

Sybase Store Procedure output is not returned getting error when running Fetch #200

Open sur2rock opened 2 years ago

sur2rock commented 2 years ago

When executing the Sybase store proc, it executes fine but the SP output is not returned , I think this has to do with return multiple result set flag , which I can see in Dbeaver tool and can set this when running the query as adv parameter but when connecting via jaydebeapi , there is no option for me to set this and the SP output is not available

limberger commented 7 months ago

@sur2rock did you find a solution? I have same issue here!!!

in this code:

   cursor=conn.cursor() 
    try:
        cursor.execute("EXEC [xx].[xxx].[PROC]")
    except BaseException as e:
        print("exception")
        print(e)
    print(f"cursor.rowcount: {cursor.rowcount}")
    print(f"cursor.description: {cursor.description}")

The exception is not launched... Output: cursor.rowcount = 1 and cursor.description = None

if i try a cursor.fetchall() occurs a jaydebeapi.Error without message ...