ODBC Error Occurs While Trying to Save Currency Values in Oracle Database - System Administration - Cloud - Foundation 24.1 - Foundation 24.1 - Ready - OnBase - Essential - Premier - Standard - external - Standard - Premier - Essential

Cloud System Administration

Platform
OnBase
Product
System Administration - Cloud
Release
Foundation 24.1
License
Standard
Premier
Essential

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.