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
Any help would be greatly appreciated :)