Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODBC Connection to Oracle database- no data returned from Views

user641396Jun 19 2020 — edited Jun 22 2020

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

Comments

Post Details

Added on Jun 19 2020
4 comments
1,210 views