Re: ORA-12705 error with TORA, sqlplus works fine

John Doe wrote:
> 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.

Your NLS_LANG looks valid.
I don't know TORA, can it possibly have a setting to override it.

> 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!

select * from sys.V_$NLS_VALID_VALUES;

/Bent Received on Wed Aug 04 2004 - 05:56:47 CDT