topic Orcale views in QlikView

Orcale views

Mon, 08 Jul 2013 07:13:42 GMT

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 — Mon, 08 Jul 2013 07:23:58 GMT

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?

Mon, 08 Jul 2013 11:30:01 GMT

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.