----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 20, 2001 1:23 PM Subject: Re: Problems posting to [EMAIL PROTECTED] > Michael do you think you can forward, these questions to the user > community. I would appreciate your help. I can't seem to send any emails > there ([EMAIL PROTECTED]). If people can respond to me at Sumit K. > [EMAIL PROTECTED] > Thanks > Sumit > > I would appreciate if anyone can help clarify these errors: > > DBI module sucessfully installed, but when trying to run the test (make > test) before installing the DBD module, I am getting a success rate of 60%. > The error seems to be rleated to LONG data type handling. If anyone has > seen these errors before, and may know the what the impact of the errors > are and whether there are workarounds.,Our Oracle version is 8.1.7. > I would appreciate it very much. In advance, thank you for your time and > help. > > > > OUTPUT OF make test > > PERL_DL_NONLAZY=1 /opt/perl/bin/perl -Iblib/arch -Iblib/lib > -I/opt/perl/lib/5.6.0/sun4-solaris -I/opt/perl/lib/5.6.0 -e 'use > Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t > t/base..............ok > t/general...........ok > t/long..............ok 71/140# failed test 72 at line 101. ORA-24345: A > Truncation or null fetch error occurred (DBD NO_DATA: OCIAttrGet > OCI_ATTR_ROWID /LOB refetch) > t/long..............NOK 72# failed test 73 at line 102. ORA-24345: A > Truncation or null fetch error occurred (DBD NO_DATA: OCIAttrGet > OCI_ATTR_ROWID /LOB refetch) > t/long..............NOK 73# failed test 74 at line 103. ORA-24345: A > Truncation or null fetch error occurred (DBD NO_DATA: OCIAttrGet > OCI_ATTR_ROWID /LOB refetch) > t/long..............ok 77/140# failed test 78 at line 118. Strings are of > different lengths (0 vs 20), Len 0 > t/long..............NOK 78# failed test 79 at line 120. Strings are of > different lengths (0 vs 20), Len 0 > t/long..............NOK 79# failed test 80 at line 122. Strings are of > different lengths (0 vs 20), Len 0 > t/long..............ok 82/140# failed test 84 at line 136. > t/long..............NOK 84# failed test 85 at line 138. truncation error > not triggered (LongReadLen 81910, data 1) > t/long..............NOK 85# failed test 86 at line 142. (DBI::errstr > undefined) > t/long..............ok 88/140# failed test 90 at line 155. > t/long..............NOK 90# failed test 92 at line 158. > t/long..............ok 93/140# failed test 94 at line 178. Strings are of > different lengths (0 vs 71680), Len 0 > t/long..............ok 97/140# failed test 98 at line 197. (DBI::errstr > undefined) > t/long..............NOK 98# failed test 99 at line 198. Strings are of > different lengths (0 vs 10240) > t/long..............ok 100/140# failed test 101 at line 201. (DBI::errstr > undefined) > t/long..............NOK 101# failed test 102 at line 202. Strings are of > different lengths (0 vs 81920) > t/long..............ok 103/140# failed test 104 at line 229. Fetched length > 0, expected 71680 > # failed test 105 at line 230. > t/long..............ok 106/140# failed test 107 at line 101. ORA-01403: no > data found (DBD NO_DATA: OCIAttrGet OCI_ATTR_ROWID /LOB refetch) > t/long..............NOK 107# failed test 108 at line 102. ORA-01403: no > data found (DBD NO_DATA: OCIAttrGet OCI_ATTR_ROWID /LOB refetch) > t/long..............NOK 108# failed test 109 at line 103. ORA-01403: no > data found (DBD NO_DATA: OCIAttrGet OCI_ATTR_ROWID /LOB refetch) > t/long..............ok 112/140# failed test 113 at line 118. Strings are of > different lengths (0 vs 20), Len 0 > t/long..............NOK 113# failed test 114 at line 120. Strings are of > different lengths (0 vs 20), Len 0 > t/long..............NOK 114# failed test 115 at line 122. Strings are of > different lengths (0 vs 20), Len 0 > t/long..............ok 117/140# failed test 119 at line 136. > t/long..............NOK 119# failed test 120 at line 138. truncation error > not triggered (LongReadLen 81910, data 1) > t/long..............NOK 120# failed test 121 at line 142. (DBI::errstr > undefined) > t/long..............ok 123/140# failed test 125 at line 155. > t/long..............NOK 125# failed test 127 at line 158. > t/long..............ok 128/140# failed test 129 at line 178. Strings are of > different lengths (0 vs 71680), Len 0 > t/long..............ok 132/140# failed test 133 at line 197. (DBI::errstr > undefined) > t/long..............NOK 133# failed test 134 at line 198. Strings are of > different lengths (0 vs 10240) > t/long..............ok 135/140# failed test 136 at line 201. (DBI::errstr > undefined) > t/long..............NOK 136# failed test 137 at line 202. Strings are of > different lengths (0 vs 81920) > t/long..............ok 138/140# failed test 139 at line 229. Fetched length > 0, expected 71680 > # failed test 140 at line 230. > t/long..............NOK 139 > Some tests for LONG data type handling failed. These are generally Oracle > bugs. > t/long..............NOK 140Please report this to the dbi-users mailing > list, and include the > Oracle version number of both the client and the server. > Please also include the output of the 'perl -V' command. > (If you can, please study t/long.t to investigate the cause. > Feel free to edit the tests to see what's happening in more detail. > Especially by adding trace() calls around the failing tests. > Run the tests manually using the command "perl -Mblib t/long.t") > Meanwhile, if the other tests have passed you can use DBD::Oracle. > > FAILED tests 72-74, 78-80, 84-86, 90, 92, 94, 98-99, 101-102, 104-105, > 107-109, 113-115, 119-121, 125, 127, 129, 133-134, 136-137, 139-140 > Failed 36/140 tests, 74.29% okay > t/plsql.............ok 20/63ORA-02035: illegal bundled operation > combination (DBD ERROR: OCIStmtExecute) at t/plsql.t line 111. > Issuing rollback() for database handle being DESTROY'd without explicit > disconnect(). > t/plsql.............dubious > Test returned status 255 (wstat 65280, 0xff00) > DIED. FAILED tests 21-63 > Failed 43/63 tests, 31.75% okay > t/reauth............skipped test on this platform > Failed Test Status Wstat Total Fail Failed List of failed > -------------------------------------------------------------------------- ----- > t/long.t 140 36 25.71% 72-74, 78-80, 84-86, 90, 92, > 94, > 98-99, 101-102, 104-105, > 107-109, > 113-115, 119-121, 125, 127, > 129, > 133-134, 136-137, 139-140 > t/plsql.t 255 65280 63 43 68.25% 21-63 > 1 test skipped. > Failed 2/5 test scripts, 60.00% okay. 79/224 subtests failed, 64.73% okay. > *** Error code 29 > make: Fatal error: Command failed for target `test_dynamic' > > > > output of the 'perl -V' command. > > dvl(1.1)-lnmmfs06:/home/goyalsu/DBD-Oracle-1.06 >perl -V > Summary of my perl5 (revision 5.0 version 6 subversion 0) configuration: > Platform: > osname=solaris, osvers=2.7, archname=sun4-solaris > uname='sunos lnmmfs06 5.7 generic_106541-14 sun4u sparc > sunw,ultra-enterprise ' > config_args='' > hint=recommended, useposix=true, d_sigaction=define > usethreads=undef use5005threads=undef useithreads=undef > usemultiplicity=undef > useperlio=undef d_sfio=undef uselargefiles=define > use64bitint=undef use64bitall=undef uselongdouble=undef usesocks=undef > Compiler: > cc='cc', optimize='-O', gccversion= > cppflags='' > ccflags =' -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64' > stdchar='char', d_stdstdio=define, usevfork=false > intsize=4, longsize=4, ptrsize=4, doublesize=8 > d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16 > ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', > lseeksize=8 > alignbytes=8, usemymalloc=y, prototype=define > Linker and Libraries: > ld='cc', ldflags =' -L/opt/SUNWspro/WS6/lib ' > libpth=/opt/SUNWspro/WS6/lib /lib /usr/lib /usr/ccs/lib > libs=-lsocket -lnsl -ldl -lm -lc -lcrypt -lsec > libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a > Dynamic Linking: > dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' ' > cccdlflags='-KPIC', lddlflags='-G -L/opt/SUNWspro/WS6/lib' > > > Characteristics of this binary (from libperl): > Compile-time options: USE_LARGE_FILES > Built under solaris > Compiled at Feb 19 2001 10:42:57 > @INC: > /opt/perl/lib/5.6.0/sun4-solaris > /opt/perl/lib/5.6.0 > /launchnow/local/lib/site_perl/5.6.0/sun4-solaris > /launchnow/local/lib/site_perl/5.6.0 > /launchnow/local/lib/site_perl > . > > > output of make install > > Installing > /launchnow/local/lib/site_perl/5.6.0/sun4-solaris/auto/DBD/Oracle/Oracle.so > Installing > /launchnow/local/lib/site_perl/5.6.0/sun4-solaris/auto/DBD/Oracle/Oracle.bs > Files found in blib/arch: installing files in blib/lib into architecture > dependent library tree > Installing /launchnow/local/lib/site_perl/5.6.0/sun4-solaris/Oraperl.pm > Installing /launchnow/local/lib/site_perl/5.6.0/sun4-solaris/oraperl.ph > Installing /launchnow/local/lib/site_perl/5.6.0/sun4-solaris/DBD/Oracle.pm > Installing /opt/perl/man/man1/ora_explain.1 > Installing /opt/perl/man/man3/DBD::Oraperl.3 > Installing /opt/perl/man/man3/DBD::Oracle.3 > Installing /opt/perl/bin/ora_explain > Writing > /launchnow/local/lib/site_perl/5.6.0/sun4-solaris/auto/DBD/Oracle/.packlist > ## Differing version of ./Oraperl.pm found. You might like to > rm /launchnow/local/lib/site_perl/5.6.0/Oraperl.pm > ## Running 'make install UNINST=1' will unlink this file for you. > Appending installation info to > /opt/perl/lib/5.6.0/sun4-solaris/perllocal.pod
