This content has been marked as final. Show 1 reply
What's the locale for the data source and target? (Language and territory)1 person found this helpful
If its perhaps something European where 812,14 is equivalent to (i.e. AMERICAN_AMERICA) 812.34 might have a glitch on the nls parameters for the oracle session.
The numeric data types may not be correct for storing fractional values, i.e. a NUMBER(38) column will only store integer values. If there is no scale, i.e. the data type declaration is just NUMBER then fraction values won't get "lost" when stored in the table.
The 11g globalization guide, chapter "Setting Up a Globalization Support Environment" can be quite helpful if your looking at pulling data from a locale that is different from the oracle database:
There are several ways to set a different locale, it can be done via setting an environment variable at the client, adjusting database instance parameters, or just within a session, i.e.:
And ODBC and the Heterogeneous Services setups can get tricky if you are migrating to/from different locales as well. If there is any way to get the data to a flat file, there are several ways to get the data into the oracle database that work around those possible issues as well.
alter session set NLS_NUMERIC_CHARACTERS = ',.';