topic Re: How to run multiple store procedure at one time? in QlikView

How to run multiple store procedure at one time?

gireesh1216 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a stored procedure which contains multiple store procedures.I ran in SQL DEVELOPER.Hear i am getting 7 tables.But same procedure i ran in Qlikview.so I am not getting anything.

Please find my store procedure below:

This procedure running in qlikview but not getting anything...Please help me..

CREATE PROCEDURE [dbo].[MAIN_DATABASE]

BEGIN

--SP to populate Summary tab1

EXEC [A_DB_Summary]

--Sp to populate Summary tab2

EXEC [B_DB_Summary]

--SP to populate Details tab 5

EXEC [C_DB_Details]

END

Thanks

Gireesh

Re: How to run multiple store procedure at one time?

marcus_sommer — Wed, 01 Mar 2017 16:11:36 GMT

I'm not sure but I think qlik expected to receive one table by each sql-statement and not several tables. Further I'm not sure if your used db-driver could handle this scenario.

- Marcus

Re: How to run multiple store procedure at one time?

jsakalis — Wed, 01 Mar 2017 21:31:23 GMT

I executed stored procedures quite a while back and found that I had to go to:

User Preferences->Security and check "Script (Allow Database Write and Execute Statements)"

Re: How to run multiple store procedure at one time?

gireesh1216 — Thu, 02 Mar 2017 07:53:04 GMT

I check the "(Allow Database Write and Execute Statements)" option

But still not working