on 01-06-2015 9:16 AM
Hi,
I'm trying to use remote source table from an Oracle Database in HANA Studio.
I've created my remote source and added some virtual tables. I encounter an issue when I try to use fields containing decimals.
SAP DBTech JDBC: [339]: invalid number: '6,9.0'
I think it's related to NLS_NUMERIC_CHARACTERS but I don't know how to set it : as an environment variable? in the DSN definition?
If I run the following query on Oracle :
select
*
from
NLS_DATABASE_PARAMETERS ;
It gives the following results
Parameter | Value |
---|---|
NLS_LANGUAGE | FRENCH |
NLS_TERRITORY | FRANCE |
NLS_NUMERIC_CHARACTERS | , |
Thanks in advance for your help.
Christophe
Ok, for SDA the SAP HANA indexserver processes act to the Oracle database instance as a client.
So why don't you set the respective NLS environment parameters for the indexserver process, restart it and see if the conversion works as it should?
- Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.