DBI fetch gets SEGEMENTATION FAULT with new ORACLE date data type (TIMESTAMP WITH LOCAL TIME ZONE).

From: Deepak Gaur (Deepak.Gaur_at_experianems.com)
Date: 10/16/03 

To: "'dbi-users@perl.org'" <dbi-users@perl.org>
Date: Thu, 16 Oct 2003 15:27:14 -0600

Hello To All DBI Users :-),

I was trying to use DBI with a new oracle date data type called "TIMESTAMP
WITH LOCAL TIME ZONE" but the code comes back with a "Segmentation
Fault(core dumped)" error while trying to fetch data from the cursor.

I was just wondering if these new data types are supported in DBI yet or I
am doing something wrong or there is a different way of handling these new
datatypes.

I was thinking to migrate all my oracle DB tables using DATE data type to
TIMESTAMP WITH LOCAL TIME ZONE, so that i can use the time_zone session
attribute from oracle to get the right local time for lot of our
international clients. I have our application code in both PERL and Java. I
m not able to figure out how i can make it to work for perl 5.6.1, although
Java code seems to accept this new date data type without any problems with
the new JDBC driver.

Is it just me or is it a known problem?

Your comments/feedback will be highly appreciated. If you like to maintain
low traffic on this list, you can mail be directly at
deepak.gaur@experianems.com.

Thanks for taking time to read this. Apologies if you have got this email in
error and/or donot belong to dbi-users@perl.org.
Deepak Gaur.
Software Engineer.

Relevant Pages

  • Re: Insert Oracle Linked Server timestamp error...
    ... I finally did receive a response from Microsoft support, ... supported in Oracle, but basically the timestamp, clobs and blobs were out ... >>Oracle introduced a new data type timestamp, ... >>seem to be updateable or insert via SQL Server linked server. ...
    (microsoft.public.sqlserver.odbc)
  • Re: null and default value compression
    ... I am not 100% sure what you are asking but all versions of Oracle ... inserted for the row Oracle can skip even writing the null indicators ... Oracle has also recommended using what is now the varchar2 data type ...
    (comp.databases.oracle.misc)
  • Re: NUMBER(p) vs. INTEGER data type and CHAR(x) vs. VARCHAR2(x) in Oracle 10g and 9i - advantage
    ... scale) gives you an integer, constrained by a max of p digits. ... since 38 is the max precision? ... CHAR data type? ... There are numbers in the Oracle DB, the definitions of the others are types ...
    (comp.databases.oracle.server)
  • Re: Problem while migrating data with Memo content from VFP to Oracle
    ... What data type are you using on the oracle side to hold the memo data? ... What data type is VFP mapping that to when it creates the remote view? ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Todays date in Access
    ... you could use the after udate event: ... I don't see oracle, or any other platform being less lines of code. ... > I have tried putting the current date in a SQL string ... It looks OK if I change the data type in the ...
    (microsoft.public.access.formscoding)