Have been trying to get a good install all day for DBD 1.21 / DBD1.22 on Solaris 5.8, it installs now. However it still fails on the TEST_ORA table.
As I said I tried it on my Windows box using Activestate/ppm which queried the TEST_ORA table successfully The latest Solaris build I used was as follows instantclient-*10.2.0.4.0* 32bit* - this seems to be the version of instant client that works* perl, v5.8.6 built for sun4-solaris-thread-multi SunOS 5.8 Oracle 9.2.0.8.0 DBD 1.21 After running a sucessful perl Makefile.PL, make, then make test I read the following post by John http://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg32950.html I then ran the make install and re-tried my sample test but still the issue occurs, otherwsise standard SQL works fine. DBD::Oracle::db prepare failed: ORA-24334: no descriptor for this position (DBD ERROR: OCIParamGet) [for Statement "select * from TEST_ORA"] at ./popAMAError.pl line 34. The output from Make test PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/01base................ok t/10general.............# Failed test (t/10general.t at line 36) t/10general.............NOK 1# got: '-1' # expected: '256' # Failed test (t/10general.t at line 37) # got: '-1' # expected: '0' t/10general.............ok 33/33# Looks like you failed 2 tests of 33. t/10general.............dubious Test returned status 2 (wstat 512, 0x200) DIED. FAILED tests 1-2 Failed 2/33 tests, 93.94% okay t/12impdata.............ok t/14threads.............ok t/15nls.................ok t/20select..............ok t/21nchar............... Database and client versions and character sets: Database 9.2.0.8.0 CHAR set is US7ASCII (Non-Unicode), NCHAR set is AL16UTF16 (Unicode) Client 10.2.0.4 NLS_LANG is '<unset>', NLS_NCHAR is '<unset>' t/21nchar...............ok t/22nchar_al32utf8......ok t/22nchar_utf8..........ok t/23wide_db.............skipped all skipped: Database character set is not Unicode t/23wide_db_8bit........skipped all skipped: Database character set is not Unicode t/23wide_db_al32utf8....skipped all skipped: Database character set is not Unicode t/24implicit_utf8.......ok t/25plsql...............ok 42/82(DBI::errstr undefined) t/25plsql...............FAILED test 43 Failed 1/82 tests, 98.78% okay t/26exe_array...........ok t/28array_bind..........ok t/30long................ok 122/470 skipped: various reasons t/31lob.................ok t/32xmltype.............ok t/34pres_lobs...........ok t/40ph_type.............ok 3/19 Placeholder behaviour for ora_type=1 (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..............ORACLE_USERID_2 not defined. Tests skipped. skipped all skipped: no reason given t/70meta................ok t/80ora_charset.........ok 8/14# Failed test (t/80ora_charset.t at line 83) # got: '?' # expected: '°' t/80ora_charset.........NOK 9# Failed test (t/80ora_charset.t at line 84) # got: '?' # expected: '°' t/80ora_charset.........ok 12/14# Failed test (t/80ora_charset.t at line 83) # got: '?' # expected: '°' t/80ora_charset.........NOK 13# Failed test (t/80ora_charset.t at line 84) t/80ora_charset.........NOK 14# got: '?' # expected: '°' # Looks like you failed 4 tests of 14. t/80ora_charset.........dubious Test returned status 4 (wstat 1024, 0x400) DIED. FAILED tests 9-10, 13-14 Failed 4/14 tests, 71.43% okay Failed Test Stat Wstat Total Fail Failed List of Failed ------------------------------------------------------------------------------- t/10general.t 2 512 33 2 6.06% 1-2 t/25plsql.t 82 1 1.22% 43 t/80ora_charset.t 4 1024 14 4 28.57% 9-10 13-14 4 tests and 122 subtests skipped. Failed 3/28 test scripts, 89.29% okay. 7/2033 subtests failed, 99.66% okay. make: *** [test_dynamic] Error 2 On Fri, Apr 3, 2009 at 11:46 AM, Jamie Nicholson <[email protected]>wrote: > Tried this using Oracle 1.21 on my Windoze PC and it works. > Looks like I'm off to upgrade the Oracle Client as per option 2 in this > archive > > http://www.nntp.perl.org/group/perl.dbi.users/2008/04/msg32777.html >
