RE: 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/17/03


To: "'Tim.Bunce@pobox.com'" <Tim.Bunce@pobox.com>
Date: Fri, 17 Oct 2003 14:29:48 -0600

Hello Tim,

This seems to have fixed the problem.
Is there a plan to patch it with the next DBD release?

Thanks for your time.
Deepak.

-----Original Message-----
From: Andy Hassall [mailto:andy@andyh.co.uk]
Sent: Thursday, October 16, 2003 4:37 PM
To: Gaur, Deepak; dbi-users@perl.org
Subject: Re: DBI fetch gets SEGEMENTATION FAULT with new ORACLE date
data type (TIMESTAMP WITH LOCAL TIME ZONE).

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=20030514
214011.7170D29873%40chronozon.artofdns.com&rnum=4&prev=/&frame=on

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

-- 
Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)


Relevant Pages

  • Re: DBI fetch gets SEGEMENTATION FAULT with new ORACLE date data type (TIMESTAMP WITH LOCAL TIME ZO
    ... > I was just wondering if these new data types are supported in DBI yet ... > I was thinking to migrate all my oracle DB tables using DATE data ... although Java code seems to accept this new ... > date data type without any problems with the new JDBC driver. ...
    (perl.dbi.users)
  • RE: oracle win2k ORA-1222 problems
    ... AS does not provide a package, but you can and should install both DBI and DBD::Oracle from ftp.esoftmatic.com. ... Oracle is listed as "failed" if I recall correctly. ... Data Source is DBI:Oracle:Space ...
    (perl.dbi.users)
  • RE: DBI problem
    ... I had Oracle 8 all along, I upgraded to ActiveState Perl 5.8.7 from ... DBD 1.16 and DBI 1.48. ... Did you install DBD::Oracle? ...
    (perl.dbi.users)
  • RE: (Fwd) DBD:: Oracle Problems
    ... The error is being thrown inside the pl/sql procedure itself not the DBI! ... Subject: DBD:: Oracle Problems ... are receiving the following error when we execute any stored procedures. ... This email has been scanned by the MessageLabs Email Security System. ...
    (perl.dbi.users)
  • Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client in Cygwin
    ... If not: you could reinstall DBI and DBD::Oracle and make sure that your Oracle environment is set correctly. ... If you have multiple Oracle installations: set your $ENVusing the ORACLE_HOME with which you compiled your DBD::Oracle. ... If you have multiple perl installations (with DBI, DBD::Oracle) you may have to set the correct path to perl (first line of your script). ...
    (perl.dbi.users)