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

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