topic Re: Can QlikView directly read data from Oracle Stored Procedure? in QlikView

Can QlikView directly read data from Oracle Stored Procedure?

Wed, 22 Jun 2016 11:24:09 GMT

Hi,

I have one requirement where QlikView fetches data from Oracle Stored Procedure.

Can Someone please advise whether QlikView has the capability to do this. If Yes, then the mechanism to be implemented in QlikView.

Thanks in Advance.

Regards,

Laxmaiah Chowdary

Re: Can QlikView directly read data from Oracle Stored Procedure?

Anil_Babu_Samineni — Wed, 22 Jun 2016 11:30:56 GMT

Laxmaiah,

Yes, It is possible.

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: Can QlikView directly read data from Oracle Stored Procedure?

bindu_apte — Wed, 22 Jun 2016 11:32:42 GMT

Hi,

Hope this threads will help you.

Executing Stored procedure in QlikView – Learn QlikView

Fetching Oracle stored procedure data into QlikView FAILS

Re: Can QlikView directly read data from Oracle Stored Procedure?

Thu, 23 Jun 2016 07:58:07 GMT

Thank you Anil.

I have tried the above method.

It is working for Sql server database.But the similar way is not working for Oracle Stored Procedures.

Thanks,

Laxmaiah Chowdary

Re: Can QlikView directly read data from Oracle Stored Procedure?

Anil_Babu_Samineni — Thu, 23 Jun 2016 08:03:02 GMT

Laxmaiah,

I use this for oracle

SQL CALL LMS.dbo.Sp_TestQlikview('$(out)', '$(out1)');

out and out1 are the variables that i declare on the script, but you can put values too

SQL CALL LMS.dbo.Sp_TestQlikview('1', '2', 'USER_NAME');

- Anil

Re: Can QlikView directly read data from Oracle Stored Procedure?

Thu, 23 Jun 2016 08:09:57 GMT

Thank you Bindu.

I understand that the working mechanism of QlikView with SQL Server Database is not the same as with Oracle Database particularly at Stored Procedures and Functions level.

The first link directs to Sql server stored procedures. But the similar way is not working with Oracle Stored Procedures.

For the second thread, I had posted the question as well as the answer based on information from known people that QlikView reads/fetches data ONLY from Oracle FUNCTIONS and not Stored Procedures.

I desperately want a concrete evidence from somebody with examples saying QlikView can read Oracle Stored Procedure data also.

Hope you get my point and request your help on this.

Thank you,

Laxmaiah Chowdary

Re: Can QlikView directly read data from Oracle Stored Procedure?

Fri, 24 Jun 2016 07:33:31 GMT

Thanks for your time Anil.

This call performs DML operations (insert, update or alter) on table.

But fetching/reading table records through Oracle Stored Procedure fails.

I mean to say reload does not show any errors but the data is not fetched to QlikView.

Could you please check read option from Oracle SP to QV.

Thanks,

Laxmaiah Chowdary