ORA-12705 error with TORA, sqlplus works fine

From: John Doe <spammeallyoucan_at_hotmail.com>
Date: 4 Aug 2004 02:37:51 -0700
Message-ID: <2c675908.0408040137.43aeb34c@posting.google.com>

Hi,

When trying to run TORA to access an oracle 9i database, I keep getting error 12705. I have checked NLS_LANG, LANG and LC_ALL variables, they have the following settings:

NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
LANG=en_US
LC_ALL=en_US

SQLplus accesses the database without any problems, however I wouldn't inflict that program even on my worst enemies.

Googling the web I found someone who solved the problem and simply said "the NLS_LANG was wrong", without specifying any further what was wrong with it and how it was corrected.

I'm in Portugal, it might be that the language of the server is set to something different than english? How can I find out what settings would be legal? I'd like to make sure to leave a working pointer for the many people that face this problem!

Best regards,
John Received on Wed Aug 04 2004 - 04:37:51 CDT