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

[Andy Hassall]

Gaur, Deepak wrote:
> 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?

See this previous thread:

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

(patch attached to end of my reply, the 2nd message in that thread)

-- 
Andy Hassall ([EMAIL PROTECTED]) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)