cancel
Showing results for 
Search instead for 
Did you mean: 

Smart Data Access to Oracle issue

Former Member
0 Kudos

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


ParameterValue
NLS_LANGUAGEFRENCH
NLS_TERRITORYFRANCE
NLS_NUMERIC_CHARACTERS,

    

Thanks in advance for your help.

Christophe

Accepted Solutions (0)

Answers (1)

Answers (1)

lbreddemann
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi,

Thanks Lars for your reply.

I finally created a view on the oracle to manage conversions in the source system directly.

Regards

Christophe