----- 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


Reply via email to