Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have an Oracle view which has 400 records previously. with the latest update it should have 0 records. But QlikView still loading 400 records which is incorrect.
Select * from View; ---> No records (Current view and right output for Oracle SQL Developer)
QlikView ---> OLEDB Connection --> 400 records (false output. )
I have compiled the view, created new view with same logic, used direct SQL in QlikView, created new OLEDB connection but still no Luck.
I have created a table out of the view which is working perfectly fine and has zero records as expected.
It seems strange and I never faced this issue.
anyone faced this or any suggestions?
Thanks for you help in advance.
Cheers,
Manideep
@manideep78 wrote:
Dear All,
I have an Oracle view which has 400 records previously. with the latest update it should have 0 records. But QlikView still loading 400 records which is incorrect.
Select * from View; ---> No records (Current view and right output for Oracle SQL Developer)
QlikView ---> OLEDB Connection --> 400 records (false output. )
I have compiled the view, created new view with same logic, used direct SQL in QlikView, created new OLEDB connection but still no Luck.
I have created a table out of the view which is working perfectly fine and has zero records as expected.
It seems strange and I never faced this issue.
anyone faced this or any suggestions?
Thanks for you help in advance.
Cheers,
Manideep
Once you have created a connection to an Oracle database, you can select data and load it into a Qlik Sense app or a QlikView document. In Qlik Sense, you load data through the Add data dialog or the Data load editor. In QlikView, you load data through the Edit Script dialog.