jaydebeapi
jaydebeapi copied to clipboard
Sybase Store Procedure output is not returned getting error when running Fetch
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 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 ...