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

[Gaur, Deepak]

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
[EMAIL PROTECTED]

Thanks for taking time to read this. Apologies if you have got this email in
error and/or donot belong to [EMAIL PROTECTED]
Deepak Gaur.
Software Engineer.