JSchmitz has asked for the wisdom of the Perl Monks concerning the following question:

I recently upgraded Perl to 5.8.0 on a couple of production boxes here and reinstalled in the DBI and DBD modules.
All is well on 4 out of 5 of the E10Ks but this one is throwing major DBD errors. Anyone seen these specific errors?
I imagine the problem lies in one of the Oracle DBA's scripts but just thought someone may have seen something similar before. - thanks

hous1dom6-phtest- 170:/opt/phsupport/bin> /opt/phsupport/autosys/bt010 +.rc Job Run from Terminal Start: bt010 Batch Trades Thu May 29 13:27:34 CDT 2003 ********** using local version of AIM_Phoenix.pm using local version of AIM_Phoenix.pm Thu May 29 13:27:36 2003: aimsql-simple.pl: Starting /opt/phsupport/bi +n/aimsql-simple.pl Thu May 29 13:27:36 2003: aimsql-simple.pl: DBD::Oracle::st execute fa +iled: ORA-06550: line 1, column 53: PLS-00553: character set name is not recognized ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated (DBD ERROR: OCIStmtExecut +e) [for statement ``BEGIN inst.pkg_utlproc.pr_msg_log(v_success_flag +=> :1, v_err_id => '100', v_err_type => 'A', v_proc_date => pkg_utlpr +oc.fn_proc_date, v_proc_name => 'aimsql-simple.pl', v_msg_type_code = +> 'I', v_msg_desc => 'Starting /opt/phsupport/bin/aimsql-simple.pl'); + END;'' with params: :p1=undef]) at /opt/phsupport/lib/AIMLINK.pm lin +e 409. DBD::Oracle::st execute failed: ORA-00900: invalid SQL statement (DBD +ERROR: OCIStmtExecute) [for statement ``inst.pkg_utlproc.pr_msg_log(v +_success_flag => :1, v_err_id => '101', v_err_type => 'A', v_proc_dat +e => pkg_utlproc.fn_proc_date, v_proc_name => 'aimsql-simple.pl', v_m +sg_type_code => 'E', v_msg_desc => 'DBD::Oracle::st execute failed: O +RA-06550: line 1, column 53: PLS-00553: character set name is not recognized ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated (DBD ERROR: OCIStmtExecut +e) [for statement ``BEGIN inst.pkg_utlproc.pr_msg_log(v_success_flag +=> :1, v_err_id => '100', v_err_type => 'A', v_proc_date => pkg_utlpr +oc.fn_proc_date, v_proc_name => 'aimsql-simple.pl', v_msg_type_code = +> 'I', v_msg_desc => 'Starting /opt/phsupport/bin/aimsql-simple.pl'); + END;'' with params: :p1=undef]) at /opt/phsupport/lib/AIMLINK.pm lin +e 409.')'' with params: :p1=undef]) at /opt/phsupport/lib/AIMLINK.pm +line 409. Return Code = 2 Batch Trades ended with errors Thu May 29 13:27:36 CDT 2003

Replies are listed 'Best First'.
Re: DBD errors
by JSchmitz (Canon) on May 29, 2003 at 22:21 UTC
    I fixed it NLS_LANG was set wrong...

    cheers,

    Jeffery