Error expecting NLS parameter
Logesh Kumar
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.
Ron Reidy
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.
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.