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

[download]

In reply to DBD errors by JSchmitz

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.