Most likely you have a US7ASCII as your default cahset in your DB while
Perl is trying to force in something UTF8 the DB can't handle.
Usually not a problem as if you db is US7ASCII you normally do not care
about funny UTF8 characters
if you can run this
my $dbh = DBI->connect_cached('dbi:Oracle',$user_id,$password,{
RaiseError => 1,
PrintError => 0,
ShowErrorStatement => 1,
AutoCommit => 0,
ora_verbose=>6
})
that will tell me all you ncar infor and settins. I might be able to fix
the test in your case
> This is perl, v5.8.8 built for i686-linux
> Oracle client 9.2.0.4.0
> Oracle db 10.1.0.4.0 64 bit
> Red Hat Enterprise Linux ES release 3 (Taroon Update 9)
> Linux my.host.com 2.4.21-27.0.2.ELsmp #1 SMP Wed Jan 12 23:35:44 EST 2005
> i686 i686 i386 GNU/Linux
> DBD::Oracle 1.22
> DBI 1.607
>
> I've seen this mentioned several times around the net and I've seen
> responses but I've never seen the solution? Do I just need to force the
> install?
>
> Every thing works up to test and then...
>
> PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"
> "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
> t/01base..................# Test loading DBI, DBD::Oracle and version
> t/01base..................ok
> t/10general...............ok
> t/12impdata...............ok
> t/14threads...............skipped: this linux perl 5.008008 not configured
> to support iThreads
> t/15nls...................ok
> t/20select................ok
> t/21nchar.................ok
> t/22nchar_al32utf8........ok
> t/22nchar_utf8............ok
> t/23wide_db...............skipped: Database character set is not Unicode
> t/23wide_db_8bit..........skipped: Database character set is not Unicode
> t/23wide_db_al32utf8......skipped: Database character set is not Unicode
> t/24implicit_utf8.........1/74
>
> # row 4: DUMP(nch) = Typ=1 Len=4: 0,38,0,58
>
>
> # row 4: DUMP(nch) = Typ=1 Len=4: 0,38,0,58
> t/24implicit_utf8......... Dubious, test returned 4 (wstat 1024, 0x400)
> Failed 4/74 subtests
> t/25plsql.................ok
> t/26exe_array.............ok
> t/28array_bind............ok
> t/30long..................ok
> t/31lob...................ok
> t/31lob_extended..........ok
> t/32xmltype...............ok
> t/34pres_lobs.............ok
> t/40ph_type...............1/19 Placeholder behaviour for ora_type=1
> VARCHAR2 (the default) varies with Oracle version.
> Oracle 7 didn't strip trailing spaces, Oracle 8 did, until 9.2.x
> Your system doesn't. If that seems odd, let us know.
> t/40ph_type...............ok
> t/50cursor................ok
> t/51scroll................ok
> t/55nested................ok
> t/56embbeded..............ok
> t/60reauth................skipped: ORACLE_USERID_2 not defined.
> t/70meta..................ok
> t/80ora_charset...........ok
>
> Test Summary Report
> -------------------
> t/24implicit_utf8.t (Wstat: 1024 Tests: 74 Failed: 4)
> Failed tests: 33-34, 70-71
> Non-zero exit status: 4
> Files=29, Tests=2071, 36 wallclock secs ( 0.53 usr 0.06 sys + 8.87 cusr
> 1.11 csys = 10.57 CPU)
> Result: FAIL
> Failed 1/29 test programs. 4/2071 subtests failed.
> make: *** [test_dynamic] Error 255
>
> Thanks,
> John
>
>
>
