Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Smart Data Access to Oracle issue

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

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question