You'll probably save yourself a lot of hassle if you add in some code to detect that that failure is due to Oracle and generate a message to explain what's happening.
Tim. On Mon, Apr 15, 2002 at 10:12:12AM -0400, Jeff Urlwin wrote: > 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 > > > > > > > > > > > > > > >
