return table from store procedure not available

[pacman82]

return table from store procedure not available

[pacman82]

Hello @GilbertoH16

odbc2parquet does not care about the difference between calling a stored procedure or a typical query using SELECT. It just send the text representation of the SQL to the database and stores the result set if any. Since the query worked for you, it is most likely that the Stored Procedure in question does not return a result set. Please note that there are other ways for stored proceduers to return their results.

If you feel this is a Bug still, and the statement in question should have returned a result set, the fault would most likely be either with the datasource or its ODBC driver.

Best, Markus

[GilbertoH16]

after your answer, I give it a shot to diffent things and found the final answer/fix.

MSSQL allow you to not set the RETURN sentence on the store procedure and still provide results. but when we use it for other cases, like this odbc connection, it must be explicit. after changing the store procedure to specifically set the return command, everything works as it should be.

so, not sure what need to be fixed, default behavior on mssql, odbc drivers, or odbc2parquet app, but still think this is something that should be written somewhere.