Hello Tim, others, I pared down the tests as per the suggestion (push @tests) and reduced the tests to 13 by commenting out the remaining 80 tests in the ["LONG", 0, 0] set, i.e. the 80 tests in the set that passed.
At this point an interesting phenomenon occurred: the tests started failing only intermittently. I explicitly ran the tests using the DBD::Oracle 1.15 blib/lib and blib/arch components. By running the same tests with the DBD::Oracle 1.14 components I could also get intermittent failure. The intermittence of the failure in the context of fewer tests is consistent with some of the notes that Tim provided with his Google search. There, one person's workaround was to close the connection (db handle) and recreate it between inserts and selects. Thus far, the evidence is mounting in favor of an Oracle bug (as Tim suggested). I have yet to alter the LongReadLen. will keep everyone posted. Gerard -----Original Message----- From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 13:36 To: Gerard Tromp Cc: [EMAIL PROTECTED] Subject: Re: DBD:Oracle 1.15 fails for long.t test 195 to 198 (perl 5.8.3, oracle 8.1.7) On Wed, Jan 28, 2004 at 08:56:51PM -0500, Gerard Tromp wrote: > > DBD::Oracle 1.15 fails for tests 195, 196, 197 and 198 > Oracle version 8.1.7.0.0 for both server and client. If there's anyone out there using Oracle 8.1.x could you please test DBD::Oracle 1.15 and let us know if it works or not for you? > Note that DBD::Oracle 1.14 is OK (somehwat fewer tests, so perhaps the bug > isn't triggered -- I have not yet delved into the differrences between the > test sets). > > The failure is peculiar. Oracle complains about the date format being wrong, > but as I understand it the date has been OK in previous and subsequent > queries. I thought I'd seen it before. A little googling turned up these: http://www.geocrawler.com/archives/3/183/2003/1/0/10305042/ http://www.bitmechanic.com/mail-archives/dbi-users/Jun1999/0466.html http://archives.neohapsis.com/archives/php/2000-02/0000.html (search for "date format is too long for internal buffer" in that one) I can't see anything in the trace file you sent. Try running: perl -Mblib t/long.t and see for which LONG type you get the error, then try commenting out the "push @test_sets, ..." lines near the top to see if the error still happens when only that type is tested. Then also try altering the "$dbh->{LongReadLen} = 20;" at line 144 (try using 80, but make sure you're using the original oci8.c file). Then try reducing the t/long.t file down till it's as small as possible but still generates the error. Tim.
