here's the results from the script fragment you requested, hope it helps,
thanks for your assistance!!!
OCINlsEnvironmentVariableGet(1,0,93,0,2)=SUCCESS
OCINlsEnvironmentVariableGet(1,0,94,0,2)=SUCCESS
OCINlsEnvCreate(a8e8ea0,OBJECT,2,0,0,0,0,0,0,1,1)=SUCCESS
OCIHandleAlloc(ab4a710,a8e8ea4,OCI_HTYPE_ERROR,0,0)=SUCCESS
charset id=1, name=US7ASCII, ncharset id=1, name=US7ASCII (csid:
utf8=871 al32utf8=873)
OCIHandleAlloc(ab4a710,a8e8ea8,OCI_HTYPE_SERVER,0,0)=SUCCESS
OCIHandleAlloc(ab4a710,a8e8eac,OCI_HTYPE_SVCCTX,0,0)=SUCCESS
OCIServerAttach(ab59d74, ab5982c, "", 0, mode=DEFAULT,0)=SUCCESS
OCIAttrSet(ab597b8,OCI_HTYPE_SVCCTX,ab59d74,0,6,ab5982c)=SUCCESS
OCIHandleAlloc(ab4a710,a8e8eb0,OCI_HTYPE_SESSION,0,0)=SUCCESS
OCIAttrSet(ab595dc,OCI_HTYPE_SESSION,a8e4818,10,22,ab5982c)=SUCCESS
OCIAttrSet(ab595dc,OCI_HTYPE_SESSION,a8d3d58,8,23,ab5982c)=SUCCESS
OCISessionBegin(ab597b8,ab5982c,ab595dc,1,mode=DEFAULT 0)=SUCCESS
OCIAttrSet(ab597b8,OCI_HTYPE_SVCCTX,ab595dc,0,7,ab5982c)=SUCCESS
OCITransRollback(ab597b8,ab5982c,mode=DEFAULT 0)=SUCCESS
OCISessionEnd(ab597b8,ab5982c,ab595dc,mode=DEFAULT 0)=SUCCESS
OCIServerDetach(ab59d74,ab5982c,mode=DEFAULT,0)=SUCCESS
OCIHandleFree(ab595dc,OCI_HTYPE_SESSION)=SUCCESS
OCIHandleFree(ab59d74,OCI_HTYPE_SERVER)=SUCCESS
OCIHandleFree(ab597b8,OCI_HTYPE_SVCCTX)=SUCCESS
OCIHandleFree(ab5982c,OCI_HTYPE_ERROR)=SUCCESS
________________________________
From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
To: John D Parker <[EMAIL PROTECTED]>
Cc: [email protected]
Sent: Thursday, November 6, 2008 5:53:14 AM
Subject: Re: Fw: DBD::Oracle installation issues
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
>
>
>
