I tested it and I got the correct values back Looking at the error you are now getting in 10gen that is an OS related error This is the basic check that we can fork subprocesses and wait for the status after having connected to Oracle
It is only suppose to run on solaris if the oci is gt 9. In your case this is true but your DB is 9.2 which leads me to thing it is the combination of 9.2 db and solaris that is the root cause. You might not have a work around for this. I am able to get this to work on windos and linux without any problem I will look a little further though. Cheers John Scoles > 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 >> >
