HI,
I Have created an ODBC Connection to my Oracle Database. All working fine. However- when i write queries to any views- no data is returned. when i write queries to the actual tables- all is ok.
example :
select * from apps.fnd_territories_vl ; this returns no rows. i am thinking it might be to do with some language configuration setting - but i do not know how this is setup with Excel or ODBC.
the above query does return rows in Toad or SQL developer.
Anyone have any ideas ?
i recently installed Power BI desktop- so not sure if that has any relevance
kind regards
Alan