John Randorf
Member²
Upgraded version from 6.x to 7.10. Get the following "Warning" error after entering credentials for a DB..."Database character set (US7ASCII) and Client character set (C:\Ora10gic\network\admin". We use Oracle 10.1.0.3 "Instant Client" version. NLS_LANG is set in registry of Windows XP client box as AMERICAN_AMERICA.US7ASCII...have also tried WE8MSWIN1252 and WE8ISO8859P1...same issue. The error is refrencing my local ORACLE_HOME directory, however it gets truncated or that's all it's trying to show...can't tell. The Oracle Instant client is a very stripped-down version of the client...NLS_LANG is only set as a registry string...it does not get set as an environment variable (like ORACLE_HOME does). Is this warning strictly informational? It gives the option to never show again. This error is new to 7.10...nothing else in the configuration was changed. I understand the issues associated with character set mismatches...our DBs are generally US7ASCII...our clients are all different depending on locale. What is the PL/SQL client trying to read to determine the local client's NLS_Lang setting? Why is it looking inside the ORACLE_HOME directory rather than in the registry? Is it confused...expecting to see it as an environment variable instead? Any help is much appreciated. JR
