I have the same experience on Linux however on Windows all tests passes (I'm not sure if it is related to different Oracle version - test of windows Perl against Linux Oracle is OK).
Linux Oracle: 9.2.0.2 Windows Oracle: 9.2.0.1 DBI: 1.35 DBD::Oracle: 1.14 -- Petr Smejkal -- Business Systems Analyst / Country IT Cz/Sk -- +420 284 059 639 > -----Original Message----- > From: Tom Malaher [mailto:[EMAIL PROTECTED] > Sent: Friday, April 04, 2003 1:35 AM > To: [EMAIL PROTECTED] > Subject: DBD::Oracle and Oracle 9.2? > > > My sysadmin is trying to install DBD::Oracle on a Solaris box running > Oracle 9.2. > > The ph_type.t test is failing with > > PERL_DL_NONLAZY=1 ./perl "-MExtUtils::Command::MM" "-e" > "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t > t/base.......ok > t/cursor.....ok > t/general....ok > t/long.......ok > t/meta.......ok > t/ph_type....NOK 12 expected 'trailing' but got 'trailing ' > for VARCHAR2 > t/ph_type....FAILED test 12 > Failed 1/19 tests, 94.74% okay > t/plsql......ok > t/reauth.....skipped > all skipped: no reason given > t/select.....ok > Failed Test Stat Wstat Total Fail Failed List of Failed > -------------------------------------------------------------- > ----------------- > t/ph_type.t 19 1 5.26% 12 > 1 test skipped. > Failed 1/9 test scripts, 88.89% okay. 1/314 subtests failed, > 99.68% okay. > *** Error code 29 > make: Fatal error: Command failed for target `test_static' > > Is there a known problem with DBD::Oracle and Oracle 9.x? > Has Oracle changed the behavior of trailing spaces in VARCHAR2 fields? > > I've run the same test script on an oracle 8 installation > using DBD::Oracle 1.06 and DBI 1.14, and it works fine (no trailing > space is returned). > > Tom >
