Hi, We have a perl-program that uses DBD::Oracle for accessing tables in an Oracle 9-Database. Some of the tables have a column with type TIMESTAMP.
We are using DBD::Oracle-1.14 and DBI 1.38. When we execute $sth->fetchrow_array(), we get segfaults when executing the script on Windows 2000. I searched on the net and found in a thread at http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=20030514214011.7170D29873%40chronozon.artofdns.com&rnum=4&prev=/&frame=on that this is a problem in DBD::Oracle because new types of Oracle 9 are not handled currently. I looked at the beta for 1.15 of DBD::Oracle, but it doesn't contain the fix for this. Is there any chance of getting a fixed version of DBD::Oracle that can do selects with TIMESTAMP-columns? We would like to distribute the application and therefore will currently need to supply the patch and tell customers to patch DBD::Oracle, which will make installation more complicated for them. Changing the Database to other date-columns is not possible, also we would like to perform any SELECT on the database through DBD::Oracle, therefore using TO_CHAR() is also not possible for us. Thanks... Dominik.
