RE: [Zope-DB] DCOracle2 with a Stored Procedure that Returns REFCURSOR / ORA TIMESTAMP DataType Issue

2007-03-20 Thread Maan M. Hamze
data type with DCOracle2? Maan -Original Message- From: Maan M. Hamze [mailto:[EMAIL PROTECTED] Sent: Saturday, March 17, 2007 5:32 PM To: zope-db@zope.org Subject: Re: [Zope-DB] DCOracle2 with a Stored Procedure that Returns REFCURSOR m.banaouas [EMAIL PROTECTED]: options = (2714

RE: [Zope-DB] DCOracle2 with a Stored Procedure that Returns REFCURSOR

2007-03-20 Thread Maan M. Hamze
You have a point Maciej - but I got used to DCOracle2 and so far it has performed quite well. I link it with Oracle lib32 libraries, but use it with ora lib 64-bit libraries in the path. So far, there has been no issues I am aware of. The only thing that came up recently is how to use it with a

Re: [Zope-DB] DCOracle2 with a Stored Procedure that Returns REFCURSOR / ORA TIMESTAMP DataType Issue

2007-03-20 Thread Matthew T. Kromer
-DB] DCOracle2 with a Stored Procedure that Returns REFCURSOR m.banaouas [EMAIL PROTECTED]: options = (2714, + ' + + ', + 36, 1, c2) it's wrong! you must give a sequence as second parameter of execute method. So you do like this: options = (2714, '',36, 1, c2) c1.execute(sql

Re: [Zope-DB] DCOracle2 with a Stored Procedure that Returns REFCURSOR / ORA TIMESTAMP DataType Issue

2007-03-20 Thread Maciej Wisniowski
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).