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.
