topic Execute stored procedure - no issues, no data in Connectivity & Data Prep

Execute stored procedure - no issues, no data

vitaliichupryna — Tue, 21 Dec 2021 14:25:50 GMT

Hi,

In one of my application, I need to use a stored procedure with three parameters as a data source.

The main problem is always finished without issues but doesn't return any data.

On community I found a possible solution: add SET NOCOUNT = 0; statement to the stored procedure, after adding statement I executed it again and still have the same result.

What can cause such a problem?

Thanks,

Vitalii

Re: Execute stored procedure - no issues, no data

jonathandienst — Mon, 02 Mar 2020 09:22:03 GMT

Does the SP return any values when executed in another environment (SQL MS / Toad etc)? Is that the last item returned from the SP?

Re: Execute stored procedure - no issues, no data

vitaliichupryna — Mon, 02 Mar 2020 10:05:47 GMT

Hi,

Yes, SP returns data when I run it from MS SQL Server

Thanks,

Vitalii

Re: Execute stored procedure - no issues, no data

BalaBhaskar_Qlik — Mon, 02 Mar 2020 10:37:06 GMT

May be try this way:

https://community.qlik.com/t5/Qlik-Sense-App-Development/SP-not-returning-Data/td-p/1443191