On Fri, Jan 09, 2004 at 10:49:35PM -0000, Andy Hassall wrote: > Tim Bunce wrote: > > I'd be very grateful if someone could send me the output of: > > > > perl -MDBI::DBD::Metadata -e write_typeinfo_pm dbi:ODBC:dsnname > > user pass Oracle > > > > Where dsnname is an ODBC DSN that uses a recent (9.2 or at least 9.1) > > Oracle ODBC driver to talk to a similarly recent Oracle database > > server. > > I might be missing something here, but DBI::DBD::Metadata from DBI 1.40 > doesn't appear to have a write_typeinfo_pm sub. It's got write_typeinfo > though (line 308). > > $ perl -MDBI::DBD::Metadata -e write_typeinfo_pm dbi:ODBC:web test test > Oracle > > Undefined subroutine &DBI::DBD::Metadata::write_typeinfo_pm called at -e > line 1. > > write_typeinfo works, but the parameters are in a different order, which had > me confused for a bit!
Uh. Bugs in the DBI::DBD docs. Patches welcome :) > Output attached, command used was: > > $ perl -MDBI::DBD::Metadata -e "DBI::DBD::Metadata::write_typeinfo > 'Oracle','dbi:ODBC:web','test','test'" > TypeInfo.pm > > $ perl -MDBI -e 'DBI->installed_versions' > Perl : 5.008001 (MSWin32-x86-multi-thread) > OS : MSWin32 (4.0) > DBI : 1.40 > DBD::Oracle : 1.14 > DBD::ODBC : 1.06 > Forgot to mention - Oracle client & server both 9.2.0.4. Darn it! Where are the various TIMESTAMP and INTERVAL types I was expecting to find? Is the ODBC driver manager recent (v3 ODBC specs?) Tim.
