Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Can QlikView directly read data from Oracle Stored Procedure?

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

6 Replies
loveisfail
Not applicable

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

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;

Life is so rich, and we need to respect to the life !!!
bindu_apte
Not applicable

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

Not applicable

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

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

loveisfail
Not applicable

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

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

Life is so rich, and we need to respect to the life !!!
Not applicable

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

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

Not applicable

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

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