How to run multiple store procedure at one time?

[gireesh1216]

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]

AS

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

[marcus_sommer]

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

[jsakalis]

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)"

[gireesh1216]

Hi

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

But still not working