T.o.a.d

Cooperinliverp00l · 31st October 2008, 14:34

We have got TOAD at work and i'm haivng trouble querying a view on a database...Although the view is there and contains data (proved by using SQL developer client) when i query it in TOAD no data is returned.

Any ideas why this would be and how to resolve it ? It bound to be a checkbox somewhere

Big Thanks in Advance

Spacecadet · 31st October 2008, 14:51

views don't contain data

back to the problem... I've not got much in the way of TOAD experience but consider these:

are you connecting using the same user through the SQL client and TOAD?

in your TOAD connection options have a look for things like ANSI NULLS and collation these might effect query results

zara_backdog · 31st October 2008, 14:52

Silly question but have you selected the correct DB from the DB drop down in the Editor tool bar?

As a non-techie this caught me out when I used it!!!!!!!

Cooperinliverp00l · 31st October 2008, 15:01

Yep selected the right Database....and using the same log in as the other Client connection that can view the contents of a View query

???? Any more suggestions ????

moorfield · 31st October 2008, 15:10

Used TOAD here too. It's a bag'o'tulipe. Switched to Aqua Data Studio (freebie). Much happier bunny.

jkoder · 31st October 2008, 19:03

What happens when you run the query? Do you see "0 rows returned" on the toolbar at the bottom? Can you see data in the view when you use schema browser and list the tables?

adestor · 1st November 2008, 20:23

Aqua data studio free ? My A*se - I donwloaded it and its a 14 day eval. AND it's a sloooooow java app. S0d that. Anyway, nothing wrong with TOAD. From what's been described this seems to be a wrong schema thing.

Bob Dalek · 5th November 2008, 16:56

Quote:

Originally Posted by moorfield

Used TOAD here too. It's a bag'o'tulipe. Switched to Aqua Data Studio (freebie). Much happier bunny.

Thanks! Will check it out. TOAD is plop.

Bob Dalek · 5th November 2008, 16:57

Quote:

Originally Posted by Cooperinliverp00l

We have got TOAD at work and i'm haivng trouble querying a view on a database...Although the view is there and contains data (proved by using SQL developer client) when i query it in TOAD no data is returned.

Any ideas why this would be and how to resolve it ? It bound to be a checkbox somewhere

Big Thanks in Advance

If it's the correct schema and the underlying tables contain data and the query SHOULD return data, then time to think about VPD.

lightng · 5th November 2008, 17:29

Have you tried comparing other tables / views using both client tools. Do you get similar results?

Are you using the same connection methods TNS, basic, JDBC Url etc between the two client tools?