Member Avatar for Antenka

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:

Locale.setDefault(Locale.US);

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 :)

  • 2 Contributors
  • 2 Replies
  • 143 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Antenka
Member Avatar for Antenka

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

commented: Great! +6
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.