Logesh, What was the value of NLS_LANG **before** you set it to "American"? Did you have other NLS* environment variables set?
>From the error docs: $ oerr ora 12705 12705, 00000, "invalid or unknown NLS parameter value specified" // *Cause: The NLS parameter value specified in an alter session statement // is not valid or not implemented. // *Action: There is a doc on metalink (note # 158654.1) that discusses this issue. -- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: logesh kumar [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 9:21 PM To: dbi-users@perl.org Subject: Error expecting NLS parameter Hi all, I am a new member of this group and I am currently working by connecting database to Perl.The following are the steps that I followed for making Perl code connect to the database. 1. Brought the "ppm" command prompt. 2. Installed DBI. 3. Installed DBD:Oracle. When I connected to the database through Perl,I got the following error message: " DBI connect('ora9inw1','lbhoobal1',...) failed: ORA-12705: invalid or unknown NL S parameter value specified (DBD ERROR: OCISessionBegin) at C:\Perl\bin\nsample. pl line 58 Error : ORA-12705: invalid or unknown NLS parameter value specified (DBD ERROR: OCISessionBegin)" However when I set NLS parameter as "NLS_LANG=American" of the concerned database,I am relieved of this error. But my objective is to dynamically connect to different database based on the user input. Can anyone help me in resolving this issue? Thanks in advance, Lokesh --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click. This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.