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/

In article <Y1jKh.97$6M.20 (AT) news (DOT) get2net.dk>,
Michael Zedeler <michael (AT) zedeler (DOT) dk> wrote:
I ran into something similar trying to get some simple scripts using
"grep" to work under both FreeBSD and Cygwin.

"grep" wouldn't find matches for a string under Cygwin, but it did under FreeBSD.

I eventually modified the scripts to try to match only the alphanumeric characters.

I think this is a problem with the MS Windows command shell and the way it treats
characters; Cygwin bash uses the command shell and obviously doesn't do everything
the same way as bash on some UNIX(tm) variant OS.

Mike Squires

"Michael Zedeler" <michael (AT) zedeler (DOT) dk> a écrit dans le message de news: Y1jKh.97$6M.20 (AT) news (DOT) get2net.dk...
What is your server Oracle version?
What is your client Oracle version?

Regards
Michel Cadot