topic exec store procedure form sql server Qlikview in QlikView

exec store procedure form sql server Qlikview

jsobrinho — Sat, 16 Nov 2024 19:10:43 GMT

Hi guys,

I am trying to exec the procedure by OLEDB connection in Qlikview. Its possible connect but doesn't return value of my store procedure, its missing something, any configuration?

temp:
LOAD *
SQL EXECUTE SP_Teste 'Param'

Re: exec store procedure form sql server Qlikview

rubenmarin — Sat, 08 Feb 2020 09:32:02 GMT

Hi, I think you need a semicolon to end load sentence, wich loads values of the next sentence

LOAD *;
SQL EXECUTE SP_Teste 'Param';

Re: exec store procedure form sql server Qlikview

jsobrinho — Mon, 17 Feb 2020 17:43:15 GMT

HI thank you so much, but my problem was access.

Thank you