jaydebeapi icon indicating copy to clipboard operation
jaydebeapi copied to clipboard

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

Open sur2rock opened this issue 4 years ago • 2 comments

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

sur2rock avatar Nov 01 '21 17:11 sur2rock

@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 ...

limberger avatar Feb 01 '24 17:02 limberger