Re: Charset problems when connecting from cygwin

"Michael Zedeler" <michael_at_zedeler.dk> a écrit dans le message de news: Y1jKh.97$6M.20_at_news.get2net.dk...
| Hi everyone.
|
| 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?
|
| Regards,
|
| Michael.
| --
| 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 http://michael.zedeler.dk/

What is your server Oracle version?
What is your client Oracle version?

Regards
Michel Cadot Received on Fri Mar 16 2007 - 06:25:56 CET