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.

Reply via email to