topic Re: Calling Stored Procedure in Qlikview in QlikView

Calling Stored Procedure in Qlikview

Fri, 21 Dec 2012 05:24:27 GMT

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.

Re: Calling Stored Procedure in Qlikview

sreenivas — Fri, 21 Dec 2012 06:09:12 GMT

Try This

Sql exec StoredProcedurename Param1,Param2;

Re: Calling Stored Procedure in Qlikview

Fri, 21 Dec 2012 06:13:34 GMT

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

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

Re: Calling Stored Procedure in Qlikview

Fri, 21 Dec 2012 06:40:09 GMT

hi manish

see this link

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

hope it help you.

Re: Calling Stored Procedure in Qlikview

sreenivas — Fri, 21 Dec 2012 07:29:22 GMT

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;

Re: Calling Stored Procedure in Qlikview

Fri, 21 Dec 2012 09:03:10 GMT

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

Re: Calling Stored Procedure in Qlikview

sreenivas — Fri, 21 Dec 2012 09:05:21 GMT

Sorry Manish I did not work on Oracle

Re: Calling Stored Procedure in Qlikview

Thu, 02 Jun 2016 14:32:17 GMT

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 oracle table

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

Thanks a lot in advance.

Regards,

Laxmaiah Chowdary