cx-oracle-users — Primary discussion list for users (and developers) of cx_Oracle

[cx-oracle-users] How to optimize (Pro*C is 5x faster)?

[Christopher J. B. <cjb...@al...>]

I have some code structured like this:

curs.execute(some_sql)
rows.fetchmany()
while rows:
        for row in rows:
                compiled_curs.execute(None, row[0], row[2])
                more_rows = compiled_curs.fetchmany()
                while more_rows:
                        #do something with them
                        more_rows = compiled_curs.fetchmany()
        rows = curs.fetchmany()
# arraysize is set to 3000 for both cursors

The problem is that it is so slow.  Yes, I realize that its not good to
execute sql in a large for loop, but my problem is that this code is
something like 5x as slow as the corresponding Pro*C code.

Whats going on?  Am I just not using the cx_Oracle module efficiently?  Why
is embedding sql in Pro*C code *so* much faster.

Thanks for the help, I hate coding in Pro*C and C ever since I learned
Python...please tell me I'm doing something wrong, I'd hate to go back to
C!

P.S.  I'm using cx_Oracle-4.1-beta1.

Re: [cx-oracle-users] Feature request - Query timeouts

[Anthony T. <an...@co...>]

If its available in the OCI I'm sure something could be arranged. Could 
you give me a pointer to the particular part of the OCI you are 
referring to? Thanks.

Leith Parkin wrote:

>Hi,
>
>Just having a bit of a look around OCI and some of the JDBC drivers
>which seem to implement a query timelimit. Would it be possible to add
>this functionality to cx_Oracle?
>
>Regards,
>
>Leith
>
>
>-------------------------------------------------------
>SF email is sponsored by - The IT Product Guide
>Read honest & candid reviews on hundreds of IT Products from real users.
>Discover which products truly live up to the hype. Start reading now. 
>http://productguide.itmanagersjournal.com/
>_______________________________________________
>cx-oracle-users mailing list
>cx-...@li...
>https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>  
>

[cx-oracle-users] Feature request - Query timeouts

[Leith P. <lei...@gm...>]

Hi,

Just having a bit of a look around OCI and some of the JDBC drivers
which seem to implement a query timelimit. Would it be possible to add
this functionality to cx_Oracle?

Regards,

Leith

Re: [cx-oracle-users] Question on Cx_Oracle module on Fedora Core 3 and AIX

[Anthony T. <an...@co...>]

It depends on the shell.

For bash/ksh and friends use

export ORACLE_HOME=<value>

For csh use

setenv ORACLE_HOME <value>

That said, Oracle has a script (oraenv for bash/ksh and coraenv for csh) 
that will do all of this for you. This script is installed during a 
normal installation of Oracle. In general then you do the following:

. oraenv

which will run the script, prompting you for the information it 
requires. This kind of stuff you can find more information about in the 
manuals that Oracle provides.

Robert, Andrew wrote:
> That's sounds like a plan.
> 
> Stupid question though.
> 
> How do you set ORACLE_HOME?
> 
> 
> Thank you,
> Andrew Robert
> Systems Architect
> Information Technology - OpenVMS
> Massachusetts Financial Services
> Phone:  617-954-5882
> Pager:   781-764-7321
> E-mail:  ar...@mf...
> Linux User Number: #201204
> 
> -----Original Message-----
> From: cx-...@li...
> [mailto:cx-...@li...] On Behalf Of Mihai
> Ibanescu
> Sent: Monday, November 29, 2004 11:42 AM
> To: cx-...@li...
> Subject: Re: [cx-oracle-users] Question on Cx_Oracle module on Fedora
> Core 3 and AIX
> 
> On Mon, Nov 29, 2004 at 11:23:39AM -0500, Robert, Andrew wrote:
> 
>>Hi Everyone,
>>
>>
>>In an effort to learn Python better as well as tie it in to my
> 
> everyday
> 
>>work, I would like to find a suitable Python module for Oracle v9
>>databases that works under both Linux and AIX.
>>
>>The cx_Oracle module has a Windows installer that works well but the
>>RPM's available are only for RH9.
>>
>>I tried building a new rpm for Fedora Core 3 but ran into problems
> 
> with
> 
>>the SPEC file and the setup.py included in the source.
>>
>>The SPEC file is hard-coded to reference Python v2.2 and the setup.py
>>file does not have code in place to handle a sys.platform value of
>>linux2.
>>
>>Does anyone know of a way to get cx_Oracle functioning on Fedora Core
> 
> 3
> 
>>and AIX?
>>
>>Any help you can provide on this would be greatly appreciated.
> 
> 
> ftp://people.redhat.com/misa/cx_Oracle/
> 
> I am not sure about AIX; this rpm works for me on FC3 (on an amd64 box
> too!).
> As long as you have ORACLE_HOME set, it should build.
> 
> Let me know if it doesn't work for you.
> 
> Cheers,
> Misa
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now. 
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> 
> 
> "MFS Relay Service" made the following
>  annotations on 11/29/2004 11:51:33 AM
> ------------------------------------------------------------------------------
> This email communication and any attachments may contain proprietary, confidential, or privileged information.  If you are not the intended recipient, you are hereby notified that you have received this email in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited.  The sender does not waive confidentiality or any privilege by mistransmission.  If you have received this email in error, please notify the sender immediately, delete this email, and destroy all copies and any attachments.
> ==============================================================================
> 
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now. 
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

-- 
Anthony Tuininga
an...@co...

Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada  T5N 4A3
Phone:	(780) 454-3700
Fax:	(780) 454-3838
http://www.computronix.com

Re: [cx-oracle-users] Question on Cx_Oracle module on Fedora Core 3 and AIX

[Mihai I. <mi...@re...>]

On Mon, Nov 29, 2004 at 10:15:36AM -0700, Anthony Tuininga wrote:
> First, let me tell you that I am no expert on creating RPMs. I have 
> simply been using "python setup.py bdist_rpm" and posting the results. 
> They work but are fairly limited, as you already noted. :-) Misa, can 
> you indicate what is different in your RPMs? If I can use a specific 
> SPEC file which is more intelligent rather than the default one 
> generated by distutils, I'd be quite happy to do so.

I have started from python setup.py bdist_rpm  and then tailored the spec file
for my needs:

- patched cx_Oracle heavily (but the packages have been accepted for the beta
  1; the only outstanding one is the rpath one which I didn't bother to submit
  upstream because I thought it's too specific to the way I use cx_Oracle).
  Adding patches with distutils is a pain, if even possible.
- Changelog entries are nice. rpm's changelog entries should be packaging
  specific while HISTORY.txt is specific to the software that is packaged - at
  least that's how I see it.
- I have the habit of not trying to invoke python directly, but using the
  rpm macro %{__python} - just because I used to have both python 1.5 and
  python 2.2 on the same system and I was sometimes building with the
  interpreter being python2. That's not useful anymore, but I still have the
  habit :-)

I just diffed my spec file vs. a bdist_rpm one, and they only seem to be
different by the two above-mentioned ones.

I have attached the rpath patch in case anybody else is interested. This will
allow one to call cx_Oracle without having to set LD_LIBRARY_PATH in order for
the linker to find libclntsh.so

Misa

Re: [cx-oracle-users] Question on Cx_Oracle module on Fedora Core 3 and AIX

[Anthony T. <an...@co...>]

First, let me tell you that I am no expert on creating RPMs. I have 
simply been using "python setup.py bdist_rpm" and posting the results. 
They work but are fairly limited, as you already noted. :-) Misa, can 
you indicate what is different in your RPMs? If I can use a specific 
SPEC file which is more intelligent rather than the default one 
generated by distutils, I'd be quite happy to do so.

BTW, you should be able to build the cx_Oracle module from source 
yourself directly using setup.py.

Mihai Ibanescu wrote:
> On Mon, Nov 29, 2004 at 11:23:39AM -0500, Robert, Andrew wrote:
> 
>>Hi Everyone,
>>
>>
>>In an effort to learn Python better as well as tie it in to my everyday
>>work, I would like to find a suitable Python module for Oracle v9
>>databases that works under both Linux and AIX.
>>
>>The cx_Oracle module has a Windows installer that works well but the
>>RPM's available are only for RH9.
>>
>>I tried building a new rpm for Fedora Core 3 but ran into problems with
>>the SPEC file and the setup.py included in the source.
>>
>>The SPEC file is hard-coded to reference Python v2.2 and the setup.py
>>file does not have code in place to handle a sys.platform value of
>>linux2.
>>
>>Does anyone know of a way to get cx_Oracle functioning on Fedora Core 3
>>and AIX?
>>
>>Any help you can provide on this would be greatly appreciated.
> 
> 
> ftp://people.redhat.com/misa/cx_Oracle/
> 
> I am not sure about AIX; this rpm works for me on FC3 (on an amd64 box too!).
> As long as you have ORACLE_HOME set, it should build.
> 
> Let me know if it doesn't work for you.
> 
> Cheers,
> Misa
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now. 
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

-- 
Anthony Tuininga
an...@co...

Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada  T5N 4A3
Phone:	(780) 454-3700
Fax:	(780) 454-3838
http://www.computronix.com

RE: [cx-oracle-users] Question on Cx_Oracle module on Fedora Core 3 and AIX

[Robert, A. <AR...@MF...>]

That's sounds like a plan.

Stupid question though.

How do you set ORACLE_HOME=3F


Thank you,
Andrew Robert
Systems Architect
Information Technology - OpenVMS
Massachusetts Financial Services
Phone:  617-954-5882
Pager:   781-764-7321
E-mail:  ar...@mf...
Linux User Number: #201204

-----Original Message-----
=46rom: cx-...@li...
[mailto:cx-...@li...] On Behalf Of Mihai
Ibanescu
Sent: Monday, November 29, 2004 11:42 AM
To: cx-...@li...
Subject: Re: [cx-oracle-users] Question on Cx_Oracle module on Fedora
Core 3 and AIX

On Mon, Nov 29, 2004 at 11:23:39AM -0500, Robert, Andrew wrote:
> Hi Everyone,
>=20
>=20
> In an effort to learn Python better as well as tie it in to my
everyday
> work, I would like to find a suitable Python module for Oracle v9
> databases that works under both Linux and AIX.
>=20
> The cx_Oracle module has a Windows installer that works well but the
> RPM's available are only for RH9.
>=20
> I tried building a new rpm for Fedora Core 3 but ran into problems
with
> the SPEC file and the setup.py included in the source.
>=20
> The SPEC file is hard-coded to reference Python v2.2 and the setup.py
> file does not have code in place to handle a sys.platform value of
> linux2.
>=20
> Does anyone know of a way to get cx_Oracle functioning on Fedora Core
3
> and AIX=3F
>=20
> Any help you can provide on this would be greatly appreciated.

=66tp://people.redhat.com/misa/cx_Oracle/

I am not sure about AIX; this rpm works for me on FC3 (on an amd64 box
too!).
As long as you have ORACLE_HOME set, it should build.

Let me know if it doesn't work for you.

Cheers,
Misa


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.=20
http://productguide.itmanagersjournal.com/
_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users


"MFS Relay Service" made the following
 annotations on 11/29/2004 11:51:33 AM
---------------------------------------------------------------------------=
---
This email communication and any attachments may contain proprietary, =
confidential, or privileged information.  If you are not the intended =
recipient, you are hereby notified that you have received this email in =
error and that any review, disclosure, dissemination, distribution or =
copying of it or its contents is prohibited.  The sender does not waive =
confidentiality or any privilege by mistransmission.  If you have received =
this email in error, please notify the sender immediately, delete this =
email, and destroy all copies and any attachments.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

Re: [cx-oracle-users] Question on Cx_Oracle module on Fedora Core 3 and AIX

[Mihai I. <mi...@re...>]

On Mon, Nov 29, 2004 at 11:23:39AM -0500, Robert, Andrew wrote:
> Hi Everyone,
> 
> 
> In an effort to learn Python better as well as tie it in to my everyday
> work, I would like to find a suitable Python module for Oracle v9
> databases that works under both Linux and AIX.
> 
> The cx_Oracle module has a Windows installer that works well but the
> RPM's available are only for RH9.
> 
> I tried building a new rpm for Fedora Core 3 but ran into problems with
> the SPEC file and the setup.py included in the source.
> 
> The SPEC file is hard-coded to reference Python v2.2 and the setup.py
> file does not have code in place to handle a sys.platform value of
> linux2.
> 
> Does anyone know of a way to get cx_Oracle functioning on Fedora Core 3
> and AIX?
> 
> Any help you can provide on this would be greatly appreciated.

ftp://people.redhat.com/misa/cx_Oracle/

I am not sure about AIX; this rpm works for me on FC3 (on an amd64 box too!).
As long as you have ORACLE_HOME set, it should build.

Let me know if it doesn't work for you.

Cheers,
Misa

[cx-oracle-users] Question on Cx_Oracle module on Fedora Core 3 and AIX

[Robert, A. <AR...@MF...>]

Hi Everyone,


In an effort to learn Python better as well as tie it in to my everyday
work, I would like to find a suitable Python module for Oracle v9
databases that works under both Linux and AIX.

The cx_Oracle module has a Windows installer that works well but the
RPM's available are only for RH9.

I tried building a new rpm for Fedora Core 3 but ran into problems with
the SPEC file and the setup.py included in the source.

The SPEC file is hard-coded to reference Python v2.2 and the setup.py
=66ile does not have code in place to handle a sys.platform value of
linux2.

Does anyone know of a way to get cx_Oracle functioning on Fedora Core 3
and AIX=3F

Any help you can provide on this would be greatly appreciated.

Thank you,
Andrew Robert
Systems Architect
Information Technology=20
Massachusetts Financial Services
Phone:  617-954-5882
Pager:   781-764-7321
E-mail:  ar...@mf...
Linux User Number: #201204


"MFS Relay Service" made the following
 annotations on 11/29/2004 11:29:16 AM
---------------------------------------------------------------------------=
---
This email communication and any attachments may contain proprietary, =
confidential, or privileged information.  If you are not the intended =
recipient, you are hereby notified that you have received this email in =
error and that any review, disclosure, dissemination, distribution or =
copying of it or its contents is prohibited.  The sender does not waive =
confidentiality or any privilege by mistransmission.  If you have received =
this email in error, please notify the sender immediately, delete this =
email, and destroy all copies and any attachments.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

Re: [cx-oracle-users] Some build problems of cx_Oracle 4.1 beta1 on Win32

[Anthony T. <an...@co...>]

I've never built cx_Oracle on Windows using the VC++ compilers. I've 
always used gcc (http://www.mingw.org). That way the options are the 
same on all of the platforms. Distuils handles most but not all of these 
issues -- as you can see. Do you have to use VC++ or can you use the 
binaries or mingw?

BTW, gcc allows linking directly to a DLL so I have never bothered to 
build or use an import library. Thus the requirement for win32api solely 
so that I can discover the Python DLL to link against. Its unfortunate 
that distutils or Python itself doesn't provide this information. Its 
also unfortunate that VC++ doesn't provide this capability.

Harri Pasanen wrote:
> Me again, with another set of problems:
> 
> With Visual C++ 6.0 it stumbles on Variable.c, which appears to have 
> long long's in it, which Visual C++ 6.0 does not support.
> 
> Moving to VC 7.1:
> 
> With Visual C++ 7.1 I got further, but had some trouble as win32api 
> was not installed in my vc7 environment (why is it needed?)
> 
> Hand tweaking setup.py around that got me a linker warning:
> 
> LINK : warning LNK4044: unrecognized option '/s', and then it bailed 
> out trying to link against oci.dll?
> 
> setup.py line:
>  extraLinkArgs.append(os.path.join(oracleHome, "bin", "oci.dll"))
> 
> was at cause:
> 
> Changing that to:
> 
>  extraLinkArgs.append(os.path.join(oracleHome, "oci","msvc","lib", 
> "oci.lib"))
> 
> made it to link.
> 
>  (Oracle 9.2 client, Python 2.3.4, VC++7.1)
> 
> I'll continue tomorrow...
> 
> Regards, 
> 
> Harri
> 
> 
> This message, including any attachments, is intended only for the person(s) to whom it is addressed. If you received it in error, please let us know and delete the message from your system. This message may be confidential and may fall under the duty of non-disclosure. Any use by others than the intended addressee is prohibited. Trema shall not be liable for any damage related to the electronic transmission of this message, such as failure or delay of its delivery, interception or manipulation by third parties, or transmission of viruses or other malicious code.
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: InterSystems CACHE
> FREE OODBMS DOWNLOAD - A multidimensional database that combines
> robust object and relational technologies, making it a perfect match
> for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

-- 
Anthony Tuininga
an...@co...

Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada  T5N 4A3
Phone:	(780) 454-3700
Fax:	(780) 454-3838
http://www.computronix.com

Re: [cx-oracle-users] xa.h missing

[Anthony T. <an...@co...>]

Jim Baker wrote:
>   Anthony Tuininga wrote:
> 
>> Simply including the file would be simpler I'd agree but are there any 
>> implications with respect to distributing code which is not my own? Is 
>> it enough to simply state that this section of code comes from xa.h 
>> and leave it at that or is something more elaborate required? I've 
>> left it alone since in general those who are missing these files have 
>> not installed all of the developer packages for Oracle -- Oracle makes 
>> this fairly easy to do, unfortunately. Any others have comments?
>>
>> Harri Pasanen wrote:
>>
>>> Hello,
>>>
>>> I saw someone else had hit the same problem on linux, where by xa.h 
>>> header was not found.
>>>
>>> Wouldn't it be prudent to inline the relevant bits in cx_Oracle.c, as 
>>> xa.h does not seem to be a standard include?  The only place I could 
>>> find it was on a windows machine Oracle 9.2 directory, at 
>>> rdbms/demo/xa.h.
>>>
>>> I modified my local copy by adding the following in cx_Oracle.c, in 
>>> place of #include "xa.h"
>>>
>>> ...
>>
>>
> Anthony,
> 
> I agree with your decision on IP grounds.
> 
> The one time this caused an issue for us is when we tried installing 
> cx_Oracle with the new 10g Instant Client on RHEL3. Oracle on RHEL3 
> requires 10g or patches to 9iR2, available only under the support 
> contract, which is gray for us because we are outside consultants to our 
> customer with actual support; cx_Oracle requires such dev files as xa.h.
> 
> So an obvious solution for now is the full install of Oracle 10g client, 
> and building cx_Oracle on the target machine. Obviously an even easier 
> solution for Instant Client users - and that sort of describes this type 
> of user - would be an RPM for 10g. (Hint, hint! :) )

I hope to be able to do that for the next release (which will be 4.1).

> For those who don't know about the client: 
> http://www.oracle.com/technology/tech/oci/instantclient/instantclient.html.
> 
> - Jim
> 
> PS
> 
> BTW, Anthony, kudos for making such a robust & useful package available!

You're welcome.

-- 
Anthony Tuininga
an...@co...

Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada  T5N 4A3
Phone:	(780) 454-3700
Fax:	(780) 454-3838
http://www.computronix.com

Re: [cx-oracle-users] xa.h missing

[Jim B. <ma...@ji...>]

Anthony Tuininga wrote:

> Simply including the file would be simpler I'd agree but are there any 
> implications with respect to distributing code which is not my own? Is 
> it enough to simply state that this section of code comes from xa.h 
> and leave it at that or is something more elaborate required? I've 
> left it alone since in general those who are missing these files have 
> not installed all of the developer packages for Oracle -- Oracle makes 
> this fairly easy to do, unfortunately. Any others have comments?
>
> Harri Pasanen wrote:
>
>> Hello,
>>
>> I saw someone else had hit the same problem on linux, where by xa.h 
>> header was not found.
>>
>> Wouldn't it be prudent to inline the relevant bits in cx_Oracle.c, as 
>> xa.h does not seem to be a standard include?  The only place I could 
>> find it was on a windows machine Oracle 9.2 directory, at 
>> rdbms/demo/xa.h.
>>
>> I modified my local copy by adding the following in cx_Oracle.c, in 
>> place of #include "xa.h"
>>
>> ...
>
>
Anthony,

I agree with your decision on IP grounds.

The one time this caused an issue for us is when we tried installing 
cx_Oracle with the new 10g Instant Client on RHEL3. Oracle on RHEL3 
requires 10g or patches to 9iR2, available only under the support 
contract, which is gray for us because we are outside consultants to our 
customer with actual support; cx_Oracle requires such dev files as xa.h.

So an obvious solution for now is the full install of Oracle 10g client, 
and building cx_Oracle on the target machine. Obviously an even easier 
solution for Instant Client users - and that sort of describes this type 
of user - would be an RPM for 10g. (Hint, hint! :) )

For those who don't know about the client: 
http://www.oracle.com/technology/tech/oci/instantclient/instantclient.html.

- Jim

PS

BTW, Anthony, kudos for making such a robust & useful package available!

[cx-oracle-users] Some build problems of cx_Oracle 4.1 beta1 on Win32

[Harri P. <har...@tr...>]

Me again, with another set of problems:

With Visual C++ 6.0 it stumbles on Variable.c, which appears to have 
long long's in it, which Visual C++ 6.0 does not support.

Moving to VC 7.1:

With Visual C++ 7.1 I got further, but had some trouble as win32api 
was not installed in my vc7 environment (why is it needed?)

Hand tweaking setup.py around that got me a linker warning:

LINK : warning LNK4044: unrecognized option '/s', and then it bailed 
out trying to link against oci.dll?

setup.py line:
 extraLinkArgs.append(os.path.join(oracleHome, "bin", "oci.dll"))

was at cause:

Changing that to:

 extraLinkArgs.append(os.path.join(oracleHome, "oci","msvc","lib", 
"oci.lib"))

made it to link.

 (Oracle 9.2 client, Python 2.3.4, VC++7.1)

I'll continue tomorrow...

Regards, 

Harri


This message, including any attachments, is intended only for the person(s) to whom it is addressed. If you received it in error, please let us know and delete the message from your system. This message may be confidential and may fall under the duty of non-disclosure. Any use by others than the intended addressee is prohibited. Trema shall not be liable for any damage related to the electronic transmission of this message, such as failure or delay of its delivery, interception or manipulation by third parties, or transmission of viruses or other malicious code.

Re: [cx-oracle-users] CLOBVar

[Anthony T. <an...@co...>]

Ah, that points the problem out quite nicely. Thanks. I have just 
checked in changes to the type objects to name them appropriately. They 
now pickle and unpickle properly. They should have been named that way 
to begin with but when I first started working on cx_Oracle I didn't 
understand all of those things. :-)

Harri Pasanen wrote:
> On Thursday 18 November 2004 15:58, Anthony Tuininga wrote:
> 
>>Can you give me some code that demonstrates the problem? 4.1 beta 1
>>deliberately adds support for pickling of LOB variables. Up until
>>that release, you could not pickle LOB values -- you had to
>>explicitly pickle str(lobValue) or something similiar. I'd be
>>interested in tracking down this problem, though, since I'd like to
>>release cx_Oracle 4.1 at some point and I'd hate to have to
>>immediately release a patch for it! :-)
> 
> 
> I just spent some time hunting it down:
> 
> It happened when pickling 'cursor.description', when the result set 
> had a CLOB column.  It may well be that 3.1 version never hit CLOB 
> type column before, and I had code to look out for other types of 
> columns.
> 
> To reproduce, run:
> 
> import cx_Oracle, cPickle
> cPickle.dumps(cx_Oracle.CLOB)
> 
> But as 
> 
> cPickle.dumps(cx_Oracle.NUMBER)
> 
> fails as well, I suppose it is not meant to work?
> 
> -Harri
> 
> 
> 
> 
> 
> This message, including any attachments, is intended only for the person(s) to whom it is addressed. If you received it in error, please let us know and delete the message from your system. This message may be confidential and may fall under the duty of non-disclosure. Any use by others than the intended addressee is prohibited. Trema shall not be liable for any damage related to the electronic transmission of this message, such as failure or delay of its delivery, interception or manipulation by third parties, or transmission of viruses or other malicious code.
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: InterSystems CACHE
> FREE OODBMS DOWNLOAD - A multidimensional database that combines
> robust object and relational technologies, making it a perfect match
> for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

-- 
Anthony Tuininga
an...@co...

Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada  T5N 4A3
Phone:	(780) 454-3700
Fax:	(780) 454-3838
http://www.computronix.com

Re: [cx-oracle-users] CLOBVar

[Harri P. <har...@tr...>]

On Thursday 18 November 2004 15:58, Anthony Tuininga wrote:
> Can you give me some code that demonstrates the problem? 4.1 beta 1
> deliberately adds support for pickling of LOB variables. Up until
> that release, you could not pickle LOB values -- you had to
> explicitly pickle str(lobValue) or something similiar. I'd be
> interested in tracking down this problem, though, since I'd like to
> release cx_Oracle 4.1 at some point and I'd hate to have to
> immediately release a patch for it! :-)

I just spent some time hunting it down:

It happened when pickling 'cursor.description', when the result set 
had a CLOB column.  It may well be that 3.1 version never hit CLOB 
type column before, and I had code to look out for other types of 
columns.

To reproduce, run:

import cx_Oracle, cPickle
cPickle.dumps(cx_Oracle.CLOB)

But as 

cPickle.dumps(cx_Oracle.NUMBER)

fails as well, I suppose it is not meant to work?

-Harri





This message, including any attachments, is intended only for the person(s) to whom it is addressed. If you received it in error, please let us know and delete the message from your system. This message may be confidential and may fall under the duty of non-disclosure. Any use by others than the intended addressee is prohibited. Trema shall not be liable for any damage related to the electronic transmission of this message, such as failure or delay of its delivery, interception or manipulation by third parties, or transmission of viruses or other malicious code.

Re: [cx-oracle-users] CLOBVar

[Anthony T. <an...@co...>]

Can you give me some code that demonstrates the problem? 4.1 beta 1 
deliberately adds support for pickling of LOB variables. Up until that 
release, you could not pickle LOB values -- you had to explicitly pickle 
str(lobValue) or something similiar. I'd be interested in tracking down 
this problem, though, since I'd like to release cx_Oracle 4.1 at some 
point and I'd hate to have to immediately release a patch for it! :-)

Harri Pasanen wrote:
> Hi again,
> 
> I'm dealing with some legacy code that used cx_Oracle 3.1.
> 
> After testing with cx_Oracle 4.1-beta1, some part of the code calls 
> pickle, and throws:
> 
> pickle.PicklingError: Can't pickle <type 'CLOBVar'>: it's not found as 
> __builtin__.CLOBVar
> 
> I'm not yet sure what is the object in question, and does it make any 
> sense to try to pickle a CLOBVar.  
> 
> But as this looks like to be 'regression' from 3.1, I thought I'd 
> document it here on this list, just in case someone else runs to the 
> same problem.
> 
> -Harri
> 
> 
> This message, including any attachments, is intended only for the person(s) to whom it is addressed. If you received it in error, please let us know and delete the message from your system. This message may be confidential and may fall under the duty of non-disclosure. Any use by others than the intended addressee is prohibited. Trema shall not be liable for any damage related to the electronic transmission of this message, such as failure or delay of its delivery, interception or manipulation by third parties, or transmission of viruses or other malicious code.
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: InterSystems CACHE
> FREE OODBMS DOWNLOAD - A multidimensional database that combines
> robust object and relational technologies, making it a perfect match
> for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

-- 
Anthony Tuininga
an...@co...

Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada  T5N 4A3
Phone:	(780) 454-3700
Fax:	(780) 454-3838
http://www.computronix.com

Re: [cx-oracle-users] xa.h missing

[Anthony T. <an...@co...>]

Simply including the file would be simpler I'd agree but are there any 
implications with respect to distributing code which is not my own? Is 
it enough to simply state that this section of code comes from xa.h and 
leave it at that or is something more elaborate required? I've left it 
alone since in general those who are missing these files have not 
installed all of the developer packages for Oracle -- Oracle makes this 
fairly easy to do, unfortunately. Any others have comments?

Harri Pasanen wrote:
> Hello,
> 
> I saw someone else had hit the same problem on linux, where by xa.h 
> header was not found.
> 
> Wouldn't it be prudent to inline the relevant bits in cx_Oracle.c, as 
> xa.h does not seem to be a standard include?  The only place I could 
> find it was on a windows machine Oracle 9.2 directory, at 
> rdbms/demo/xa.h.
> 
> I modified my local copy by adding the following in cx_Oracle.c, in 
> place of #include "xa.h"
> 
> ------------------------------------------------
> // Inline relevant bits from non-std xa.h
> 
> /* 
>  * Transaction branch identification: XID and NULLXID:
>  */
> 
> 
> #define XIDDATASIZE 128		/* size in bytes */
> #define MAXGTRIDSIZE	64	/* maximum size in bytes of gtrid */
> #define MAXBQUALSIZE	64	/* maximum size in bytes of bqual */
> struct xid_t {
>     long	formatID;	/* format identifier */
>     long	gtrid_length;	/* value from 1 through 64 */
>     long	bqual_length;	/* value from 1 through 64 */
>     char	data[XIDDATASIZE];
> };
> typedef struct xid_t XID;
> 
> // end of inline
> ---------------------------------------------------
> 
> Now it compiles, yet to see if it actually works ;-)
> 
> 
> -Harri
> 
> 
> This message, including any attachments, is intended only for the person(s) to whom it is addressed. If you received it in error, please let us know and delete the message from your system. This message may be confidential and may fall under the duty of non-disclosure. Any use by others than the intended addressee is prohibited. Trema shall not be liable for any damage related to the electronic transmission of this message, such as failure or delay of its delivery, interception or manipulation by third parties, or transmission of viruses or other malicious code.
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: InterSystems CACHE
> FREE OODBMS DOWNLOAD - A multidimensional database that combines
> robust object and relational technologies, making it a perfect match
> for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

-- 
Anthony Tuininga
an...@co...

Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada  T5N 4A3
Phone:	(780) 454-3700
Fax:	(780) 454-3838
http://www.computronix.com

[cx-oracle-users] CLOBVar

[Harri P. <har...@tr...>]

Hi again,

I'm dealing with some legacy code that used cx_Oracle 3.1.

After testing with cx_Oracle 4.1-beta1, some part of the code calls 
pickle, and throws:

pickle.PicklingError: Can't pickle <type 'CLOBVar'>: it's not found as 
__builtin__.CLOBVar

I'm not yet sure what is the object in question, and does it make any 
sense to try to pickle a CLOBVar.  

But as this looks like to be 'regression' from 3.1, I thought I'd 
document it here on this list, just in case someone else runs to the 
same problem.

-Harri


This message, including any attachments, is intended only for the person(s) to whom it is addressed. If you received it in error, please let us know and delete the message from your system. This message may be confidential and may fall under the duty of non-disclosure. Any use by others than the intended addressee is prohibited. Trema shall not be liable for any damage related to the electronic transmission of this message, such as failure or delay of its delivery, interception or manipulation by third parties, or transmission of viruses or other malicious code.

[cx-oracle-users] xa.h missing

[Harri P. <har...@tr...>]

Hello,

I saw someone else had hit the same problem on linux, where by xa.h 
header was not found.

Wouldn't it be prudent to inline the relevant bits in cx_Oracle.c, as 
xa.h does not seem to be a standard include?  The only place I could 
find it was on a windows machine Oracle 9.2 directory, at 
rdbms/demo/xa.h.

I modified my local copy by adding the following in cx_Oracle.c, in 
place of #include "xa.h"

------------------------------------------------
// Inline relevant bits from non-std xa.h

/* 
 * Transaction branch identification: XID and NULLXID:
 */


#define XIDDATASIZE 128		/* size in bytes */
#define MAXGTRIDSIZE	64	/* maximum size in bytes of gtrid */
#define MAXBQUALSIZE	64	/* maximum size in bytes of bqual */
struct xid_t {
    long	formatID;	/* format identifier */
    long	gtrid_length;	/* value from 1 through 64 */
    long	bqual_length;	/* value from 1 through 64 */
    char	data[XIDDATASIZE];
};
typedef struct xid_t XID;

// end of inline
---------------------------------------------------

Now it compiles, yet to see if it actually works ;-)


-Harri


This message, including any attachments, is intended only for the person(s) to whom it is addressed. If you received it in error, please let us know and delete the message from your system. This message may be confidential and may fall under the duty of non-disclosure. Any use by others than the intended addressee is prohibited. Trema shall not be liable for any damage related to the electronic transmission of this message, such as failure or delay of its delivery, interception or manipulation by third parties, or transmission of viruses or other malicious code.

Re: [cx-oracle-users] Custom cursor segfaults

[Anthony T. <an...@co...>]

Ok, I tracked down the issue. Catching an exception raised during the 
execute and then blithely attempting to fetch from the cursor afterward 
is what causes the segfault. I have just checked in a change that will 
raise an InterfaceError exception when that is detected. In the 
meantime, however, you can simply __not__ perform the fetch if the 
execute has failed.... :-)

Leith Parkin wrote:
> Just a quick update, the production code differed slightly from the test rig, so that problem has been fixed.
> 
> However trying to catch DatabaseError exceptions causes the same problem. What is the work around in this instance?
> 
> On Wed, Nov 10, 2004 at 11:46:18AM +1100, Leith Parkin wrote:
> 
>>Hello all,
>>
>>Just a quick question, ive created a custom cursor that returns result sets as dicts, following on from the previous posts about custom cursors segfaulting, i modified my the code to pass the connection to the cursor. It all seems to work fine with a simple test rig, however when i combine my module with Warren Smiths DbConnectionPool, i get a segfault when returning a result set.
>>
>>Warrens module can be found at http://www.wandrsmith.net/~warren/DbConnectionPool.py
>>
>>Here is my DictWrapper module (Using 4.1 beta)
>>
>>
>>If you could provide some pointers, or if you require any further debugging info please let me know. The system is Oracle 8i with corresponding drivers.
>>
>>
>>--- snip ---
>>from cx_Oracle import *
>>
>># DictCursor for Oracle, returns dicts instead of tuples
>>class DictConnect(Connection):
>>        def cursor(self):
>>                return DictCursor(self)
>>
>>class DictCursor(Cursor):
>>    def fetchall(self):
>>        r = Cursor.fetchall(self)
>>        result = []
>>        for l in r:
>>            result.append( dict([(a[0],b) for a,b in zip(self.description, l)]) )
>>
>>        return result
>>
>>    def fetchone(self):
>>        return dict([(a[0],b) for a,b in zip(self.description, Cursor.fetchone(self))])
>>
>># factory class
>>def connect(**kw):
>>        return DictConnect(**kw)
>>
>>
>>--- snip ---
>>
>>
>>The test rig
>>
>>--- snip ---
>>
>>import OracleUtil
>>db = OracleUtil.connect(user='****', password='****', dsn='oracle')
>>c = db.cursor()
>>print c
>>c.execute('select * from some_table where x = 3')
>>print c.fetchall()
>>db.close()
>>
>>
>>
>>-------------------------------------------------------
>>This SF.Net email is sponsored by:
>>Sybase ASE Linux Express Edition - download now for FREE
>>LinuxWorld Reader's Choice Award Winner for best database on Linux.
>>http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click
>>_______________________________________________
>>cx-oracle-users mailing list
>>cx-...@li...
>>https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by:
> Sybase ASE Linux Express Edition - download now for FREE
> LinuxWorld Reader's Choice Award Winner for best database on Linux.
> http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

-- 
Anthony Tuininga
an...@co...

Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada  T5N 4A3
Phone:	(780) 454-3700
Fax:	(780) 454-3838
http://www.computronix.com

Re: [cx-oracle-users] Custom cursor segfaults

[Anthony T. <an...@co...>]

Ok, I have replicated the issue here but I haven't tracked down its 
source just yet. I'll post again when I know what the problem is. Please 
stand by.... :-)

Leith Parkin wrote:
> Just a quick update, the production code differed slightly from the test rig, so that problem has been fixed.
> 
> However trying to catch DatabaseError exceptions causes the same problem. What is the work around in this instance?
> 
> On Wed, Nov 10, 2004 at 11:46:18AM +1100, Leith Parkin wrote:
> 
>>Hello all,
>>
>>Just a quick question, ive created a custom cursor that returns result sets as dicts, following on from the previous posts about custom cursors segfaulting, i modified my the code to pass the connection to the cursor. It all seems to work fine with a simple test rig, however when i combine my module with Warren Smiths DbConnectionPool, i get a segfault when returning a result set.
>>
>>Warrens module can be found at http://www.wandrsmith.net/~warren/DbConnectionPool.py
>>
>>Here is my DictWrapper module (Using 4.1 beta)
>>
>>
>>If you could provide some pointers, or if you require any further debugging info please let me know. The system is Oracle 8i with corresponding drivers.
>>
>>
>>--- snip ---
>>from cx_Oracle import *
>>
>># DictCursor for Oracle, returns dicts instead of tuples
>>class DictConnect(Connection):
>>        def cursor(self):
>>                return DictCursor(self)
>>
>>class DictCursor(Cursor):
>>    def fetchall(self):
>>        r = Cursor.fetchall(self)
>>        result = []
>>        for l in r:
>>            result.append( dict([(a[0],b) for a,b in zip(self.description, l)]) )
>>
>>        return result
>>
>>    def fetchone(self):
>>        return dict([(a[0],b) for a,b in zip(self.description, Cursor.fetchone(self))])
>>
>># factory class
>>def connect(**kw):
>>        return DictConnect(**kw)
>>
>>
>>--- snip ---
>>
>>
>>The test rig
>>
>>--- snip ---
>>
>>import OracleUtil
>>db = OracleUtil.connect(user='****', password='****', dsn='oracle')
>>c = db.cursor()
>>print c
>>c.execute('select * from some_table where x = 3')
>>print c.fetchall()
>>db.close()
>>
>>
>>
>>-------------------------------------------------------
>>This SF.Net email is sponsored by:
>>Sybase ASE Linux Express Edition - download now for FREE
>>LinuxWorld Reader's Choice Award Winner for best database on Linux.
>>http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click
>>_______________________________________________
>>cx-oracle-users mailing list
>>cx-...@li...
>>https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by:
> Sybase ASE Linux Express Edition - download now for FREE
> LinuxWorld Reader's Choice Award Winner for best database on Linux.
> http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

-- 
Anthony Tuininga
an...@co...

Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada  T5N 4A3
Phone:	(780) 454-3700
Fax:	(780) 454-3838
http://www.computronix.com

Re: [cx-oracle-users] Custom cursor segfaults

[Leith P. <le...@sl...>]

Just a quick update, the production code differed slightly from the test rig, so that problem has been fixed.

However trying to catch DatabaseError exceptions causes the same problem. What is the work around in this instance?

On Wed, Nov 10, 2004 at 11:46:18AM +1100, Leith Parkin wrote:
> Hello all,
> 
> Just a quick question, ive created a custom cursor that returns result sets as dicts, following on from the previous posts about custom cursors segfaulting, i modified my the code to pass the connection to the cursor. It all seems to work fine with a simple test rig, however when i combine my module with Warren Smiths DbConnectionPool, i get a segfault when returning a result set.
> 
> Warrens module can be found at http://www.wandrsmith.net/~warren/DbConnectionPool.py
> 
> Here is my DictWrapper module (Using 4.1 beta)
> 
> 
> If you could provide some pointers, or if you require any further debugging info please let me know. The system is Oracle 8i with corresponding drivers.
> 
> 
> --- snip ---
> from cx_Oracle import *
> 
> # DictCursor for Oracle, returns dicts instead of tuples
> class DictConnect(Connection):
>         def cursor(self):
>                 return DictCursor(self)
> 
> class DictCursor(Cursor):
>     def fetchall(self):
>         r = Cursor.fetchall(self)
>         result = []
>         for l in r:
>             result.append( dict([(a[0],b) for a,b in zip(self.description, l)]) )
> 
>         return result
> 
>     def fetchone(self):
>         return dict([(a[0],b) for a,b in zip(self.description, Cursor.fetchone(self))])
> 
> # factory class
> def connect(**kw):
>         return DictConnect(**kw)
> 
> 
> --- snip ---
> 
> 
> The test rig
> 
> --- snip ---
> 
> import OracleUtil
> db = OracleUtil.connect(user='****', password='****', dsn='oracle')
> c = db.cursor()
> print c
> c.execute('select * from some_table where x = 3')
> print c.fetchall()
> db.close()
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by:
> Sybase ASE Linux Express Edition - download now for FREE
> LinuxWorld Reader's Choice Award Winner for best database on Linux.
> http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

[cx-oracle-users] Custom cursor segfaults

[Leith P. <le...@sl...>]

Hello all,

Just a quick question, ive created a custom cursor that returns result sets as dicts, following on from the previous posts about custom cursors segfaulting, i modified my the code to pass the connection to the cursor. It all seems to work fine with a simple test rig, however when i combine my module with Warren Smiths DbConnectionPool, i get a segfault when returning a result set.

Warrens module can be found at http://www.wandrsmith.net/~warren/DbConnectionPool.py

Here is my DictWrapper module (Using 4.1 beta)


If you could provide some pointers, or if you require any further debugging info please let me know. The system is Oracle 8i with corresponding drivers.


--- snip ---
from cx_Oracle import *

# DictCursor for Oracle, returns dicts instead of tuples
class DictConnect(Connection):
        def cursor(self):
                return DictCursor(self)

class DictCursor(Cursor):
    def fetchall(self):
        r = Cursor.fetchall(self)
        result = []
        for l in r:
            result.append( dict([(a[0],b) for a,b in zip(self.description, l)]) )

        return result

    def fetchone(self):
        return dict([(a[0],b) for a,b in zip(self.description, Cursor.fetchone(self))])

# factory class
def connect(**kw):
        return DictConnect(**kw)


--- snip ---


The test rig

--- snip ---

import OracleUtil
db = OracleUtil.connect(user='****', password='****', dsn='oracle')
c = db.cursor()
print c
c.execute('select * from some_table where x = 3')
print c.fetchall()
db.close()

RE: [cx-oracle-users] OCI.DLL cannot be found ?

[Nik B. <Nik...@pe...>]

> This is definitely an Oracle client issue -- the server software is 
> irrelevant, actually. In general, make sure that if you are running 
> Oracle 8i on the client you are using the Oracle 8i version 
> of cx_Oracle and if you are running Oracle 9i on the client make sure you 
> are using the Oracle 9i version of cx_Oracle. As mentioned earlier, the
only 
> exception is Oracle 9.0.1 which doesn't have the required procedure. 
> Make sense?

About as much as Oracle stuff ever does :-) Something was definitely out of
the norm with our product client install, as neither the 8i or 9i
"prepackaged" build of cx_Oracle worked, which is why I ended up recompiling
it. However we've now moved on to 9i so the problem has gone away.

Great news that it works on 10g; I may be able to offer to test it on a
Windows platform in the not too distant future...!

Nik

Re: [cx-oracle-users] oracle 10g support

[Michael M. <mi...@ma...>]

On Oct 14, 2004, at 18:44, Anthony Tuininga wrote:

> Oracle 10g is definitely supported. I simply haven't provided binaries 
> yet -- you'll have to build it yourself. I have only built cx_Oracle 
> for 10g on Linux (where it works just fine) but don't have access to a 
> Windows box running Oracle 10g just yet. Does that answer your 
> question?
>

It also builds and works fine on Mac OS X 10.3.

Michael


> Zed Lopez wrote:
>> Hi,
>> I'm working on advocating the use of Python for a large project at
>> work and something that could be a deal-breaker is whether there's
>> support for a direct (non-ODBC) connection to Oracle 10g. Could anyone
>> please tell me whether there are plans for a 10g version of cx-oracle?
>> Thanks.
>> -------------------------------------------------------
>> This SF.net email is sponsored by: IT Product Guide on 
>> ITManagersJournal
>> Use IT products in your business? Tell us what you think of them. 
>> Give us
>> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find 
>> out more
>> http://productguide.itmanagersjournal.com/guidepromo.tmpl
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
> -- 
> Anthony Tuininga
> an...@co...
>
> Computronix
> Distinctive Software. Real People.
> Suite 200, 10216 - 124 Street NW
> Edmonton, AB, Canada  T5N 4A3
> Phone:	(780) 454-3700
> Fax:	(780) 454-3838
> http://www.computronix.com
>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: IT Product Guide on 
> ITManagersJournal
> Use IT products in your business? Tell us what you think of them. Give 
> us
> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out 
> more
> http://productguide.itmanagersjournal.com/guidepromo.tmpl
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>
-- 
Michael Maibaum
internet: mi...@ma...    |    http://mike.maibaum.org
voice:     [m] 07958 604025        |