Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2004
    Posts
    7

    Unanswered: sqlldr loading error with numeric field

    Hi,

    I would like to load a file which have the numeric field with point(english locale) in a database with the french locale.

    English locale | French locale
    9.2 | 9,2

    How can i do?
    Shall i change the database's locale?
    Or
    A SQL*Loader option exist to convert decimal point to decimal comma?

    Thanks, a lot.

  2. #2
    Join Date
    May 2003
    Location
    France
    Posts
    112

    Re: sqlldr loading error with numeric field

    Try to change:
    export NLS_NUMERIC_CHARACTERS=".,"
    in your environment

    Originally posted by laurent.marquez
    Hi,

    I would like to load a file which have the numeric field with point(english locale) in a database with the french locale.

    English locale | French locale
    9.2 | 9,2

    How can i do?
    Shall i change the database's locale?
    Or
    A SQL*Loader option exist to convert decimal point to decimal comma?

    Thanks, a lot.

  3. #3
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    if all else fails, try reading the 9 and 2 seperatly (making 92) and deviding it by 10...

    Regards

  4. #4
    Join Date
    Jan 2004
    Posts
    7

    Re: sqlldr loading error with numeric field

    Originally posted by ndu35
    Try to change:
    export NLS_NUMERIC_CHARACTERS=".,"
    in your environment
    I m on a windows 200 server,
    and NLS_NUMERIC_CHARACTERS doesn't work!
    even with cygwin.

    Maybe the same environment variable exist on windows?

  5. #5
    Join Date
    Jan 2004
    Posts
    7
    Originally posted by namliam
    if all else fails, try reading the 9 and 2 seperatly (making 92) and deviding it by 10...

    Regards
    for me it's easier to replace "point" by "comma" in the numeric field
    but too long.

  6. #6
    Join Date
    Jan 2004
    Posts
    7

    Re: sqlldr loading error with numeric field

    Originally posted by laurent.marquez
    I m on a windows 200 server,
    and NLS_NUMERIC_CHARACTERS doesn't work!
    even with cygwin.

    Maybe the same environment variable exist on windows?
    I found a request to access to NLS_NUMERIC_CHARACTERS
    SELECT * FROM V$PARAMETER;

    How can i modify it?

    this doesn't work:

    UPDATE V$PARAMETER param
    SET param.VALUE = '.,'
    WHERE param.NAME = 'nls_numeric_characters';

    ORA-02030: can only select from fixed tables/views

  7. #7
    Join Date
    May 2003
    Location
    France
    Posts
    112

    Re: sqlldr loading error with numeric field

    You can modifiy NLS_NUMERIC_CHARACTERS in your init.ora but i think there is some key in the registry for Oracle.

    Originally posted by laurent.marquez
    I found a request to access to NLS_NUMERIC_CHARACTERS
    SELECT * FROM V$PARAMETER;

    How can i modify it?

    this doesn't work:

    UPDATE V$PARAMETER param
    SET param.VALUE = '.,'
    WHERE param.NAME = 'nls_numeric_characters';

    ORA-02030: can only select from fixed tables/views

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •