(I change title of thread since it is a new subject)
The problem with TIMESTAMP appears on Windows XP professional also which is
a 32-bit system. This is where I got an actual error message that the
datatype SQLT_TIMESTAMP can not be handled.
On Solaris, I link DCOracle2 against oracle 32-bit libs
(/oracle/10.1.0/product/lib32), but I use it with LD_LIBRARY_PATH pointing
to the 64-bit libs (product/lib). This has been the case since Oracle 8i if
I remember correctly and I never ran into an issue on Solaris or WIndows XP
for this matter, with what I do.
However, my guess is that this got nothing to do with it since error appears
also on Windows XP.
Are you actually fetching timestamp values in your select queries and in
your stored procedures, and it is working fine?
Maan
----- Original Message -----
From: "Maciej Wisniowski" <[EMAIL PROTECTED]>
To: "Maan M. Hamze" <[EMAIL PROTECTED]>
Cc: <zope-db@zope.org>
Sent: Wednesday, March 21, 2007 1:46 AM
Subject: Re: [Zope-DB] DCOracle2 with a Stored Procedure that Returns
REFCURSOR / ORA TIMESTAMP DataType Issue
This was causing a segmentation fault on a Sun Solaris box.
On Windows, I got an actual error message. While fetching, the cursor
has a field of ora datatype TimeStamp. This was crashing DCOracle2. a
to_char solved the issue.
I am using DCOracle2 and Oracle 10 on Solaris (and Windows XP).
Did anyone run into issues of handling TimeStamp oracle data type with
DCOracle2?
We had problems with segmentation faults on 64 bit systems.
We didn't realized what caused this (except that it was DCOracle2).
Problem appeared only under high load of our servers so it was hard
to debug. On 32 bit systems everything was ok. Is your problem with
TimeStamp related to 64 bit platform or it happens on 32 bit platforms
too?
--
Maciej Wisniowski
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db
