Yes -- Oracle fails the test. That fact is documented in the POD and it's due to the fact that the ODBC driver doesn't notify the caller (via SQLDescribeParam) that it's a date field and tells the caller everything is a varchar. It then proceeds to ignore the ODBC date format.
This is expected -- until Oracle fixes it... Jeff > My environment: > > Windows 2000 SP2, ActiveState Perl 5.6.1 build 629, > DBI v1.21, DB client/DB server=Oracle 8.1.7 > > when running nmake test, I received following error: > > C:\temp\DBD-ODBC-0.40>nmake test > > Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 > Copyright (C) Microsoft Corp 1988-1998. All rights reserved. > > C:\bin\Perl\bin\Perl.exe -Mblib -IC:\bin\Perl\lib > -IC:\bin\Perl\lib -e " > use Test::Harness qw(&runtests $verbose); $verbose=0; runtests > @ARGV;" t\01base. > t t\02simple.t t\03dbatt.t t\05meth.t t\07bind.t t\08bind2.t t\09multi.t > Using C:/temp/DBD-ODBC-0.40/blib > t\01base............ok > t\02simple..........ok > t\03dbatt...........ok > t\05meth............ok > t\07bind............ok > t\08bind2...........ok 2/3DBD::ODBC::st execute failed: > [Oracle][ODBC][Ora]ORA-0 > 1858: a non-numeric character was found where a numeric was expected > (SQL-S1000)(DBD: st_execute/SQLExecute err=-1) at t/ODBCTEST.pm line 210. > t\08bind2...........FAILED test 3 > Failed 1/3 tests, 66.67% okay > t\09multi...........skipped test on this platform > Failed Test Status Wstat Total Fail Failed List of Failed > ------------------------------------------------------------------ > -------------- > > t\08bind2.t 3 1 33.33% 3 > 1 test skipped. > Failed 1/7 test scripts, 85.71% okay. 1/46 subtests failed, 97.83% okay. > NMAKE : fatal error U1077: 'C:\bin\Perl\bin\Perl.exe' : return code '0xff' > Stop. > > MaT > > > -----Original Message----- > > From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] > > Sent: Friday, April 12, 2002 5:22 PM > > To: [EMAIL PROTECTED] > > Cc: [EMAIL PROTECTED] > > Subject: FW: CPAN Upload: J/JU/JURL/DBD-ODBC-0.40.tar.gz > > > > > > Most significant change is the change in the default binding > > type which forces DBD::ODBC to attempt to determine the bind > > type if one is not passed. I decided to make this the default > > behavior to make things as simple as possible. > > > > Fixed connection code put in 0.39 to work correctly. > > > > Two minor patches for building, one for Cygwin one > > if both iODBC and unixODBC libraries are installed. > > Probably need better command line on this, but if > > someone has the problem, please let me know (and > > hopefully send a patch with it). > > > > > > > > The uploaded file > > > > DBD-ODBC-0.40.tar.gz > > > > has entered CPAN as > > > > file: $CPAN/authors/id/J/JU/JURL/DBD-ODBC-0.40.tar.gz > > size: 66801 bytes > > md5: bb75ff8ef7ca0559079d9d6e7983c824 > > > > No action is required on your part > > Request entered by: JURL (Jeff Urlwin) > > Request entered on: Fri, 12 Apr 2002 15:18:58 GMT > > Request completed: Fri, 12 Apr 2002 15:20:17 GMT > > > > Virtually Yours, > > Id: paused,v 1.80 2002/03/10 06:40:03 k Exp k > > > > > > > >
