This content has been marked as final. Show 2 replies
Can anyone please help me understand this?
The HS_LANGUAGE parameter has 3 sections -
For example, in your settings -
The 'territory' part will be either 'America' or 'Korea' and this specifies the conventions for day and week numbering, default date format, decimal character delimiter and group separator, of ISO and local currency symbols.
The problem you are seeing is because there is a difference between the decimal separator used in your Oracle database and the Korean SQL*Server database. When there is a difference this can cause the information after the decimal to be lost.
If you have access to My Oracle Support the following note has more information -
Gateway and Decimal Digits (Doc ID 1453148.1)
When you set the territory to 'AMERICA' then the decimal separator used by the non-Oracle database is recognised correctly and no data is lost.
You could check but you should find the SQL*Server database uses a comma (or other character) as a separator and Oracle uses a decimal point or it is the other way round.