ORA-12705 invalid or unknown NLS parameter value specified
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-12705 invalid or unknown NLS parameter value specified

  1. #1
    Join Date
    Nov 2000
    Location
    New Delhi, India
    Posts
    81

    Unhappy

    Hello !!

    I'm facing a strange problem. I get the above mentioned error as soon as
    I try connecting to the 8i database using Pro*C. I'm running the code on the
    server itself. The o/s is Windows NT. The error doesn't come when I connect sqlplus.

    I checked the NLS parameters using DBA Studio and found
    NLS_LANGUAGE is set to AMERICAN
    NLS_TERRITORY is set to AMERICA

    Should I try installing Oracle afresh.

    Thanks.

    Regards
    Shruti

    [Edited by ShrutiM on 08-01-2001 at 02:18 AM]

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    When getting an ORA-12705 error on a PROC application check the registry settings for a 32-bit program or the ORACLE.INI if it is a 16-bit program. As a quick fix you can simply delete the NLS_LANG parameter is they are using the default, (AMERICAN_AMERICA.WE8ISO8859P1).
    The ultimate solution is to re-install everything as this is caused by some
    component version conflict between:
    A) the product
    B) the Required Support Files
    C) SQL*net

    In case of any help please be free to ask me at rohitsn@altavista.com

    Regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com

  3. #3
    Join Date
    Nov 2000
    Location
    New Delhi, India
    Posts
    81
    Thanks Rohit.

    I'll try and get back to you.

  4. #4
    Join Date
    Nov 2000
    Location
    New Delhi, India
    Posts
    81

    Wink Thanks!!!

    Thanks Rohit,

    It worked, I checked the registry anf Found
    NLS_LANG was set to NA
    I modified it to AMERICAN and the application worked.
    Is this some kind of Oracle Bug??

    Regards
    Shruti

Posting Permissions

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


Click Here to Expand Forum to Full Width