DBD::Oracle - Support for TIMESTAMP

From: Dominik Stadler (dstadler_at_ftisoft.at)
Date: 12/16/03 

To: dbi-users@perl.org
Date: Tue, 16 Dec 2003 12:01:20 +0100

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.

Relevant Pages

  • DBD::Oracle 1.15 patch for truncated UTF-8 errors
    ... > systems with more recent versions of Oracle. ... The following patch is needed to make DBD::Oracle 1.15 run ... I believe that with more traditional setup with UTF-8 both database ... and perl -V. ...
    (perl.dbi.users)
  • Re: 10g Database not starting after applying patch
    ... Now i cannot get the database started. ... Before applying the patch, i closed all of the services involved w/ ... started the oracle lisnter. ... Details ORA-12505: TNS:listener does not currently know of SID ...
    (comp.databases.oracle.server)
  • Re: Database is up or down
    ... The database is down because Oracle tells you so. ... Patch it up to 9.2.0.8. ... lucky, whatever has brought down your instance might have ...
    (comp.databases.oracle.server)
  • Diff. type of Patches in RDBMS
    ... If we want to upgrade the oracle software from 10.2.0.1 to 10.2.0.3 ... For this we need to download the binary patch and this ... to upgrade my database from x.x.0.1 to x.x.0.2 ... I checked under patches ...
    (comp.databases.oracle.server)
  • Re: What so special about PostgreSQL and other RDBMS?
    ... That's exactly the link the licence agreement for the database points to when it ... comes to what wecan expect for paying support. ... > "Oracle may provide additional releases or versions of its programs ... If the requirements are volatile I'd do a long term contract detailing what ...
    (comp.lang.php)