Error expecting NLS parameter

--0-1693894783-1130991670=:92011
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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.
--0-1693894783-1130991670=:92011--

RE: Error expecting NLS parameter

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:vt9132004@yahoo.com]=20
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:=20
=20
" 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)"
=20
However when I set NLS parameter as "NLS_LANG=3DAmerican" of the
concerned database,I am relieved of this error.
=20
But my objective is to dynamically connect to different database based
on the user input. Can anyone help me in resolving this issue?
=20
Thanks in advance,
Lokesh

=09
---------------------------------
Yahoo! FareChase - Search multiple travel sites in one click. =20

This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
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.