Re: [Zope-DB] [ANN] Modified version of DCOracle2 is available

2006-12-04 Thread Maan M. Hamze
Maceij - I still do not understand how to get hold of the new dco2.c file (along with other files in the DCOracle2 package). You state right from the start: ** Code is here: http://code.google.com/p/dcoracle2da/ Should be available via svn with: svn checkout http://dcoracle2da.go

RE: [Zope-DB] [ANN] Modified version of DCOracle2 is available

2006-12-04 Thread Maan M. Hamze
Thanks Maceij for the information - >>Currently I had not much time to do something with this project, >>but I'll try to make it cleaner soon, write some tests (so far I was >>not able to run original tests...) and to put this into official Zope >>repositories. I use DCOracle2 with Sun Solaris an

[Zope-DB] DCOracle2 with a Stored Procedure that Returns a ref_cur

2007-03-16 Thread Maan M. Hamze
I am using DCOCralce2 with Python 2.41, and Oracle 9. I have a stored procedure (sp1) that takes 4 IN parameters, with one OUT parameter. The OUT parameter is a **ref_cursor** that holds a data set. I am doing the following: db = DCOracle2.connection(connectionString) C1 = db.cursor() C2 = db.curs

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

2007-03-17 Thread Maan M. Hamze
invalid data type bound Printing options yield: >> print options (5920, '', 36, 1, ) Would this be causing the invalid data type bound error above? Also, should not the following work: c2 = c1.storedProcedureName(2714, '', 36, 1) ?? Maan Maan M. Hamz

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-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 a ref_cur

2007-03-21 Thread Maan M. Hamze
- Original Message - From: "Matthew T. Kromer" <[EMAIL PROTECTED]> To: "Maan M. Hamze" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, March 20, 2007 8:17 PM Subject: Re: [Zope-DB] DCOracle2 with a Stored Procedure that Returns a ref_cur If I recall, DCOra

[Zope-DB] DCOracle2 TIMESTAMP DataType Issue

2007-03-21 Thread Maan M. Hamze
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

[Zope-DB] DCOracle2 TIMESTAMP DataType Issue

2007-03-21 Thread Maan M. Hamze
r" <[EMAIL PROTECTED]> To: "Maan M. Hamze" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, March 20, 2007 8:32 PM Subject: Re: [Zope-DB] DCOracle2 with a Stored Procedure that Returns REFCURSOR / ORA TIMESTAMP DataType Issue Chances are good that the C code that is trying to constr

[Zope-DB] RE: DCOracle2 TIMESTAMP DataType Issue

2007-03-21 Thread Maan M. Hamze
dingArrayObject *self, int item) Maan -----Original Message- From: Maan M. Hamze [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 21, 2007 4:04 AM To: zope-db@zope.org Cc: Matthew T. Kromer Subject: DCOracle2 TIMESTAMP DataType Issue I checked dco2.c yesterday and I did notice that the

[Zope-DB] RE: DCOracle2 TIMESTAMP DataType Issue - Resolved :-)

2007-03-22 Thread Maan M. Hamze
news. You know, I love your implementation with these converters. This dco2.c is a gem of a code piece of writing. Thanks for your help, Maan -Original Message- From: Matthew T. Kromer [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 5:42 AM To: Maan M. Hamze Cc: zope-db

[Zope-DB] DCOracle2 and x86_64

2007-03-22 Thread Maan M. Hamze
Maceij - You got the following: gcc -pthread -shared ./dco2.o -L/opt/oracle/client.9/product/lib32/ -lclntsh -Wl,-rpath,/opt/oracle/client.9/product/lib -o ./dco2.so BOTH oracle lib directories should be lib32. In the above, you have one pointing to lib32 and the other one to lib. Change the

AW: [Zope-DB] [ANN] Modified version of DCOracle2 is available - RE Dr. Klaus Happle fixes

2007-12-02 Thread Maan M. Hamze
Hello - I was checking your fixes (Dr. Klaus Happle) for the two functions in dco2.c: (RE: http://mail.zope.org/pipermail/zope-db/2006-November/004812.html ) static PyObject *Cursor_ResultSet(Cursor *self, int count)and static PyObject *Cursor_fetch(Cursor *self, PyObject *args) I noticed tha

[Zope-DB] compiling dco2.c with Oracle 10g using mingw on Windows XP - interesting errror

2007-12-05 Thread Maan M. Hamze
I compiled dco2.c on Solaris 9 with Oracle 9i and Oracle 10g with no problems. On Windows XP, compiling dco2.c with Oracle9i is fine. With Oracle 10g on Windows XP (using Mingw C compiler), I ran into following errors: # In file included from C:/oracle/ora10/oci/include/oci.h:3

RE: [Zope-DB] compiling dco2.c with Oracle 10g using mingw on Windows XP - interesting errror

2007-12-06 Thread Maan M. Hamze
zember 2007 18:32:14 -0600 "Maan M. Hamze" <[EMAIL PROTECTED]> wrote: > I compiled dco2.c on Solaris 9 with Oracle 9i and Oracle 10g with no > problems. > On Windows XP, compiling dco2.c with Oracle9i is fine. > > With Oracle 10g on Windows X