SQL*PLUS version 9.2.0.1.0

[acarroll]

Hi,
I have recently installed SQL*PLUS 9.2 on my machine(Windows 2000). The installation did not install an Admin folder initally, I created the Admin folder myself in c:\Oracle\Ora92\Network and placed my TNSNames.ora file there.

I am able to connect to the database ok, but when I run a bit of sql I get "no rows returned".....I have tried the same piece of SQL on another machine running SQL*PLUS 8.0.6.0.0, connecting to the same database using the same username and password and the sql returns data....

Have I done anything wrong in adding the Admin folder myself??

Any help is greatly appreciated!

Aileen

 

[sem]

In most cases it's due to NLS-related settings: default to_[date|number|char] conversions. A can't propose other versions, because have no information about your queries. Apparently you might also connect to another schema/database that accidentally contained objects with same names

Regards, Dima

 

[alexhu]

Do you get the error with seelcts on V$ or Dba_ views ?

Alex

 

[alexhu]

Do you get the error with selects on V$ or Dba_ views ?

Alex

 

[Turkbear]

Hi are the 2 tnsnames.ora files identical?
Oracle does not 'care' how the Network/Admin directory got there ( in fact you need not place your tnsnames.ora file in that directory, you can specify where it is with an environment variable called TNS_ADMIN set to the directory where you have the file,or with a registry setting)..

Does the banner you get after connecting to the instance show the correct info for that database?
What do you get with a

select sysdate from dual;

Also be sure no other tnsnames.ora files exist on your client..

 

[wchuacs]

No rows returned means the table you selected has no data. Isn't that obviously?

If you have no problem connecting to database. Please tell us what userid you used to connect.