Skip Menu |
 

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the DBD-Oracle CPAN distribution.

Report information
The Basics
Id: 49436
Status: resolved
Priority: 0/
Queue: DBD-Oracle

People
Owner: Nobody in particular
Requestors: hull [...] snap.com
Cc:
AdminCc:

Bug Information
Severity: Normal
Broken in: 1.23
Fixed in:
  • 1.24
  • 1.24a
  • 1.24b

Attachments


Subject: Patch to add support for a few Oracle data types to type_info_all
Download (untitled) / with headers
text/plain 235b
The attached patch adds information for TIMESTAMP WITH TIME ZONE, INTERVAL DAY TO SECOND, and INTERVAL YEAR TO MONTH to type_info_all. I believe that all the fields are correct, although I have to admit that I guessed on some of them.
Subject: DBD-Oracle-type_info_all.patch
--- Oracle.pm.orig 2009-04-29 08:04:24.000000000 -0700 +++ Oracle.pm 2009-09-04 10:16:01.000000000 -0700 @@ -729,6 +729,68 @@ undef, 1,1,0,undef,0,undef, "CLOB", undef,undef,SQL_LONGVARCHAR, undef,undef,undef, ], if $version >= 8; + push @$type_info_all, + [ "TIMESTAMP WITH TIME ZONE", # type name + SQL_TYPE_TIMESTAMP_WITH_TIMEZONE, # data type + 40, # column size + "TIMESTAMP'", # literal prefix + "'", # literal suffix + "precision", # create params + 1, # nullable + 0, # case sensitive + 3, # searchable + undef, # unsigned attribute + 0, # fixed prec scale + 0, # auto unique value + undef, # local type name + 0, # minimum scale + 6, # maximum scale + SQL_TIMESTAMP, # sql data type + 5, # sql datetime sub + undef, # num prec radix + undef, # interval precision + ], + [ "INTERVAL DAY TO SECOND", # type name + SQL_INTERVAL_DAY_TO_SECOND, # data type + 22, # column size '+00 11:12:10.222222200' + "INTERVAL'", # literal prefix + "'", # literal suffix + "precision", # create params + 1, # nullable + 0, # case sensitive + 3, # searchable + undef, # unsigned attribute + 0, # fixed prec scale + 0, # auto unique value + undef, # local type name + 0, # minimum scale + 9, # maximum scale + SQL_INTERVAL, # sql data type + 10, # sql datetime sub + undef, # num prec radix + undef, # interval precision + ], + [ "INTERVAL YEAR TO MONTH", # type name + SQL_INTERVAL_YEAR_TO_MONTH, # data type + 13, # column size '+012345678-01' + "INTERVAL'", # literal prefix + "'", # literal suffix + "precision", # create params + 1, # nullable + 0, # case sensitive + 3, # searchable + undef, # unsigned attribute + 0, # fixed prec scale + 0, # auto unique value + undef, # local type name + 0, # minimum scale + 9, # maximum scale + SQL_INTERVAL, # sql data type + 7, # sql datetime sub + undef, # num prec radix + undef, # interval precision + ], + if $version >= 10; return $type_info_all; }
pathch added to trunk you can find it here http://svn.perl.org/modules/dbd-oracle/trunk


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.