Hello, I was wondering if anyone had come up against this problem or error reported from DBI using Oracle:
DBD::Oracle::st execute failed: ORA-06550: line 3, column 38: PLS-00553: character set name is not recognized ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated (DBD ERROR: OCIStmtExecute) at ./newd.pl line 197. the weird thing is we are getting this only on some machines, and on scripts but not others. I reset the ORACLE_HOME env variable and the LD_LIBRARY_PATH variable and recompiled the Oracle DBD on the offending machine, and it actually stopped this from happening on some of the scripts, whereas other scripts will still not stop throwing this error. Really strange! We have tried setting the NS_LANG env variable and it has had no effect (save for breaking things completely if the wrong value is set.) if it helps, the ones that are working ok now are apache perl scripts (mod_perl) and the ones that are offending the most are daemons (perl scripts) that don't run inside apache. Any ideas, anyone? We are on Solaris 2.8, Oracle 8i, Perl 5.6.1, apache 1.3.19, mod_perl 1.26. Thanks in advance. Sincerely, ---------------------------------------- Hugh J. Hitchcock Sr. Software Engineer / Project Manager Tiaxa, Inc. http://www.tiaxa.com
