Jan-19-2019, 06:28 PM
Hi Team,
I am trying to use sqlanydb Python API to invoke a stored procedure deployed in Sybase IQ. I am calling this stored procedure successfully in any of the DB Tool like DBArtison and DBVisualizer (possibly using JDBC driver). I can always return results.
Unfortunately I am using given sample to execute this stored procedure but getting funny error saying failed to insert into a temp table. This actually happened right after a inner stored procedure call of my stored procedure.
I remember I encountered similar situation using pyodbc before but issue cleared after adding "SET ANSINULL OFF" in the top. I tried here but it doesn't turn out to have the same happy ending.
I tried couple tweaking over past few days 12 hours per day but this i still not working.
Do you have any suggestion?
Thanks.
Fortitude
I am trying to use sqlanydb Python API to invoke a stored procedure deployed in Sybase IQ. I am calling this stored procedure successfully in any of the DB Tool like DBArtison and DBVisualizer (possibly using JDBC driver). I can always return results.
Unfortunately I am using given sample to execute this stored procedure but getting funny error saying failed to insert into a temp table. This actually happened right after a inner stored procedure call of my stored procedure.
I remember I encountered similar situation using pyodbc before but issue cleared after adding "SET ANSINULL OFF" in the top. I tried here but it doesn't turn out to have the same happy ending.
I tried couple tweaking over past few days 12 hours per day but this i still not working.
Do you have any suggestion?
Thanks.
Fortitude