Thanks for replying, Steve. The stored proc is ok, I have checked that. If I remove @table variable or #temp_table and replace it with an actual work table, it works fine and I don’t receive the previous error. It makes me think that we can’t use @table variable or #temp_table in stored procs when using SQL Adaptor… is that so?
Search this Site:
Recent Posts
- Logic App Consumption deployment: The secret of KeyVault parameter cannot be retrieved. Http status code: ‘Forbidden’. Error message: ‘Access denied to first party service
- BizTalk Server Visual Studio project: attempted re-targeting of the project has been canceled.
- BizTalk Oracle Adapter error: The assembly required for type mapping not found.
- PowerShell script to identify all SQL V1 actions and triggers inside Logic Apps Consumption
- Friday (funny) Fact: There is no size limit for the Logic App parameter name