Hi, I've got some error reports from testing DBD::Oracle. and the test scripts asked me to post the stuff here. The system that compiled DBD::Oracle is. Redhat 6.2 out of thebox. Perl 5.6 stable compiled & installed. Oracle 8.1.7 default install. Connecting via SQLNET to an oracle 8.0.5 database. The tests are being ran against the 8.0.5 database, so that might be the problem. Here's the error log. ESC[L_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/local/lib/perl5/5.6.0/i686-linux -I/usr/local/lib/perl5/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 83/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 89/140# failed test 90 at line 155. t/long..............ok 91/140# 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 t/long..............NOK 104# 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 118/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 124/140# failed test 125 at line 155. t/long..............ok 126/140# 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 t/long..............NOK 139# failed test 140 at line 230. t/long..............NOK 140 Some tests for LONG data type handling failed. These are generally Oracle bugs. Please 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 : The system
