dbTalk Databases Forums  

Charset problems on Oracle

comp.databases comp.databases


Discuss Charset problems on Oracle in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Michael Zedeler
 
Posts: n/a

Default Charset problems on Oracle - 03-11-2007 , 09:15 AM






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 AMERICAN_AMERICA.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.

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/

--
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/

Reply With Quote
  #2  
Old   
Ed Prochak
 
Posts: n/a

Default Re: Charset problems on Oracle - 03-11-2007 , 08:27 PM






On Mar 11, 10:15 am, Michael Zedeler <mich... (AT) zedeler (DOT) dk> wrote:
Quote:
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 AMERICAN_AMERICA.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.

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.
Ask in comp.databases.oracle.tools or maybe in comp.lang.perl
Ed




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.