Skip to Content
avatar image
Former Member

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


Parameter Value NLS_LANGUAGE FRENCH NLS_TERRITORY FRANCE NLS_NUMERIC_CHARACTERS ,

    

Thanks in advance for your help.

Christophe

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 26, 2015 at 09:32 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Thanks Lars for your reply.

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

      Regards

      Christophe