Issue: When trying to save currency values from an Oracle Client using one locale to an Oracle database using another locale, an ODBC error occurs. This ODBC error is not limited to currency values; it can occur when trying to save floating point values and other formats that could be affected by locale.
Resolution: The ODBC error is caused by the differences in system locales. If a client machine is running a locale that is different from the database server locale, an environment variable called NLS_LANG must be created and configured correctly on the machine that is receiving the ODBC errors to accommodate the difference. For more information about this environment variable, please contact your Database Administrator.