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

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

2007-03-20 Thread Matthew T. Kromer
e-db@zope.org Subject: Re: [Zope-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

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 Maan M. Hamze
TimeStamp oracle 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 PROTECTE

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

2007-03-17 Thread Maan M. Hamze
"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, options) -- I tried it both ways. Wi