Hello, everybody.
I had a problem while connecting to Oracle. Got messages:

ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified

And found solution for this - setting the default locale in java code:


This works just fine for me. BUT if on target machine Oracle would have other locale? Is there any chance that I can programmatically obtain the Locale, which is set for Oracle at runtime (and not connecting to it, because for connecting I should change default locale if it differs)? Or maybe there's more clear way to solve that problem (with no locale switching) ..

By the way, I use:
Oracle 10.2 XE
JDeveloper 11g

Any help would be greatly appreciated :)

Oh, my! Might be, but wasn't good enough. How could I miss that OraLocaleInfo ? One more stupid mistake in my list :D

Thank you sooo much

This question has already been answered. Start a new discussion instead.