Calling Stored Procedure in Qlikview

[#1]

Hi Guys

I have a Sql Stored Procedure which has 2 input parameters and 2 output parameters . I am calling it in a following ways:

Load * ;

Sql

Declare @out int

Declare @out1 int

Exec LMS.dbo.Sp_TestQlikview 1,7,@out Output,@out1 Output

Select @out as Output

Select @out1 as Output1;

The problem is that i am getting only Output in Qlikview not Output1.

[sreenivas]

Try This

Sql exec StoredProcedurename Param1,Param2;

[#3]

how i will get a output parameters in Qlikview ????????

i have 2 output parameters also which i want to use it in qlikview

[#4]

hi manish

see this link

http://community.qlik.com/thread/3223

hope it help you.

[sreenivas · Accepted solution]

Try This

Load * ;

Sql

Declare @out int

Declare @out1 int

Exec LMS.dbo.Sp_TestQlikview 1,7,@out Output,@out1 Output

Select @out as Output, @out1 as Output1;

[#6]

hi Sreenivas

Thanks for the reply ..

Can you please tell how to call  the same kind of procdure in Qlikview from oracle .

i mean to say 2 input parameters and 2 output parameters

[sreenivas]

Sorry Manish I did not work on Oracle

[#8]

Hi,

Thank you for the inputs!!.

Could you please help in integrating oracle stored procedure data with QlikView.

I have tried all the above changes.

But I am not able to fetch Oracle stored procedure data into QlikView as well as insert records into Oracle table through stored procedure.

I have posted the issue in forum atQlikView integration with Oracle Stored procedure FAILS in fetching data and inserting data to oracl...

Could you please take a look at and advise for corrections.

Thanks a lot in advance.

Regards,

Laxmaiah Chowdary