ORA-12705 error while connection to oracle9i

lamp has asked for the wisdom of the Perl Monks concerning the following question:

Greetings Monks,

I am using DBI and DBD oracle under XP. The perl compiler which I am using is Active(5.8.4). When i try to connect to oracle9i, i am getting the following error.

"Can't connect: ORA-12705: invalid or unknown NLS parameter value specified (DBD ERROR: OCISessionBegin) at first.pl line 11."

Can someone throw some light about the same.

Thank you in advance

Comment on ORA-12705 error while connection to oracle9i

Replies are listed 'Best First'.
Re: ORA-12705 error while connection to oracle9i by gellyfish (Monsignor) on Jul 28, 2005 at 11:15 UTC
It is probable that your `NLS_LANG` environment variable is set to an invalid language. /J\	[reply] [d/l]
Re: ORA-12705 error while connection to oracle9i by marto (Cardinal) on Jul 28, 2005 at 11:24 UTC
Hi, I'm pretty sure that gellyfish is correct. In your post you probably should have supplied the code you were using to try and connect. Have you read the DBD::Oracle documentation? Before asking a database related question ... may also be worth a look if you have not done so already. Martin	[reply]
Re: ORA-12705 error while connection to oracle9i by Ben Win Lue (Friar) on Jul 29, 2005 at 12:08 UTC
Hi lamp, have you already solved your problem? I encountered just an hour ago the same error. My NLS_LANG was not set and even if I set NLS_LANG=GERMAN I still get -12705!	[reply]