Charset problems when connecting from cygwin

From: Michael Zedeler <>
Date: Thu, 15 Mar 2007 22:38:55 +0100
Message-ID: <Y1jKh.97$>

[Quoted] Hi everyone.

[Quoted] I have written a perl script that tries to insert data into a table in an Oracle database residing on an aix server. Running the perl script on the server works fine, but if I try running it on my local machine (cygwin on Windows XP), I get this message:

DBD::Oracle::st execute failed: ORA-06550: line 9, column 20: PLS-00553: character set name is not recognized

The database uses DANISH_DENMARK.WE8MACROMAN8S, but I am completely at a loss wrt what to do to make perl/DBD::Oracle/the Oracle client library behave as it should.

The data I try to insert into the database is from an ISO-8859-1 encoded file.

I tried setting NLS_LANG to the same charset as the database claims it is using when I log on this gave me ORA-12705: Cannot access NLS data files or invalid environment specified. It seems that the client is trying to find some sort of conversion table that is unavailable.

I am using the latest XE client.

My question is: what kind of trickery on the client side do I need to make the script run in the environment described above?



Which is more dangerous? TV guided missiles or TV guided families?
I am less likely to answer usenet postings by anonymous authors.
Visit my home page at
Received on Thu Mar 15 2007 - 22:38:55 CET

Original text of this message