Orcale views

[#1]

Hi,

already i am loading views from oracle database.

yesterday, we created one new view in oracle DB, when i try to pull that table using qlikview, its not pulling the data.

it pulls only the structure with 0 rows.

at the same time, i queried the database using sqlplus, it pulls the data.

Could anyone help to resolve this issue.

driver : OLEDB

DB: Oracle 11g 64 bit.

thanks in advance.

[Gysbert_Wassenaar]

Are you using the same oracle user credentials in sqlplus and for the oledb connection?

Are you using the original oracle oledb driver or one from Microsoft?

Do you get the same result if you use the odbc driver?

[#3]

Hi,

I am using the same user credentials in sql plus and oledb connection.

i am using the original oledb driver.

when i pull the table using odbc driver in my local system, its pulling the table.