Unfortunately, that didn't work. I have a minimal Oracle installation on the Linux machine; just the libraries necessary to get DBD::Oracle to build. I don't even have $ORACLE_HOME defined when running. DBD::Oracle complains but runs. This works fine for nearly everything, but when I use bind_param with the PL/SQL - "DEFINE variable NUMBER := ?; ... " , I get this error message. Possibly Oracle is trying to deliver some error message but can't because there are not enough language files? Changing the PL/SQL so the variables are interpolated into the statement - "DEFINE variable NUMBER := $initial; ..." runs with no errors, so at least I have a work-around. Straight SQL with bind_param works with no errors. Weird.
> -----Original Message----- > From: Orlando Andico [mailto:[EMAIL PROTECTED]] > Sent: Sunday, April 07, 2002 5:14 AM > To: Joseph Pepin > Cc: [EMAIL PROTECTED] > Subject: Re: PLS-00553: character set name is not recognized > > > On Fri, 5 Apr 2002, Joseph Pepin wrote: > ... > > Anybody got any idea what this means? This happened on a > Linux box from > > some SQL that used bind_param. The exact same program on a > Solaris box > > executed without error. > > > > ORA-06550: line 2, column 28: > > PLS-00553: character set name is not recognized > > ORA-06550: line 0, column 0: > > PL/SQL: Compilation unit analysis terminated (DBD ERROR: > OCIStmtExecute) > > You probably need to set the ORA_NLS and NLS_LANG environment > variables > properly. Strictly speaking this is a UNIX/Linux configuration issue > (unless you set them via $ENV in Perl), not in Oracle, which > could account > for the difference in behavior between Linux and Solaris. > > For example, I usually create a file /etc/profile.d/oracle.sh > (on RedHat > 6.x/7.x) which sets a few environment variables globally > (yeah I should > be using TWO_TASK but I'm not): > > #!/bin/sh > # oracle setup > export ORACLE_HOME=/opt/oracle/8.1.7 > export PATH=$PATH:$ORACLE_HOME/bin > export ORACLE_SID=XXXX > export NLS_LANG="american_america.we8iso8859p1" > export ORA_NLS=$ORACLE_HOME/ocommon/nls/admin/data > > > -- > Orlando Andico <[EMAIL PROTECTED]> > Mosaic Communications, Inc. >
