Unable to access View in TOAD for Oracle, but can see in SQL Developer [message #666658] |
Sun, 19 November 2017 23:12 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/de238f604a934bd08279140d72d7c02f?s=64&d=mm&r=g) |
nickz
Messages: 39 Registered: September 2013 Location: US
|
Member |
|
|
I am using TOAD for Oracle version 11.0.5.1. I am able to see a View in an Oracle schema when I login using Oracle SQL Developer. But, when using TOAD, I am NOT able to access the View or see any data in it. For another View, I can access the View, but it doesn't return any data. I am able to access other DB objects though. Any idea why I can see via Oracle SQL Developer and not via TOAD in the same PC, same database, same schema?
I also tried in another system (PC) where TOAD 12.6.053 is installed, and I was able to access the views, and see data when I query it. Not sure if there is any session or NLS parameters that might be causing this. Please help.
P.S. - This view that I am trying to access is in another schema, but I have access to query the view. Hence, I am able to access and see the data through Oracle SQL Developer.
|
|
|
Re: Unable to access View in TOAD for Oracle, but can see in SQL Developer [message #666659 is a reply to message #666658] |
Sun, 19 November 2017 23:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/136107.jpg) |
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
nickz wrote on Sun, 19 November 2017 21:12I am using TOAD for Oracle version 11.0.5.1. I am able to see a View in an Oracle schema when I login using Oracle SQL Developer. But, when using TOAD, I am NOT able to access the View or see any data in it. For another View, I can access the View, but it doesn't return any data. I am able to access other DB objects though. Any idea why I can see via Oracle SQL Developer and not via TOAD in the same PC, same database, same schema?
I also tried in another system (PC) where TOAD 12.6.053 is installed, and I was able to access the views, and see data when I query it. Not sure if there is any session or NLS parameters that might be causing this. Please help.
P.S. - This view that I am trying to access is in another schema, but I have access to query the view. Hence, I am able to access and see the data through Oracle SQL Developer.
How can we reproduce what you report?
You claim a problem exists, but show us NOTHING!
|
|
|
|