Re: [cx-oracle-users] cx_oracle for oracle client 10.1

[Anthony T. <ant...@gm...>]

Hi,

First, if you can at all do so, please upgrade to 10.2. It will make
your life a whole lot simpler. :-)

10.1 will work with cx_Oracle BUT you cannot use the 10g release as I
build against 10.2 and there are a few things that won't work properly
because of the differences between the two releases. If you build
yourself with the 10.1 client then it will build and work properly for
you. You can make use of the 9i build if one is available but as you
can see I no longer build those either so you'll have to find someone
else to build for you as I no longer have 9i or 10.1 and I have no
intention of installing them any longer. Sorry!

See below for a few other notes.

On Sat, Jul 16, 2011 at 3:23 AM, bagheera <neo...@go...> wrote:
>
> Hi, i need to use cx_oracle with oracle 10.1.0.4 client, but any recent
> release doesn't work, i can't succesfully import cx_oracle. I have found
> information that i might use cx_oracle for 9i, so i installed python 2.6.6
> and cx_oracle 4.4.1 for oracle 9i and it does work, i mean i can import
> module. Unfortunatly i can't revice data from my queries.
>
> On most recent  version of cx_oracle for oracle 10.2, python 2.7 my
> query.fetchall() gives result:
>
> [('889476',), ('864365',), ('886811',), ('886054',), ('885968',)]
>
> but when i try to execute that on other machine, with oracle client 10.1,
> python 2.6 and cx_oracle 4.4.1, i get:
>
>
> cursor.execute(zapytanie)
> [<cx_Oracle.STRING with value [None, None, None, None, None, None, None,
> None, N
> one, None, None, None, None, None, None, None, None, None, None, None,
> None, Non
> e, None, None, None, None, None, None, None, None, None, None, None, None,
> None,
>  None, None, None, None, None, None, None, None, None, None, None, None,
> None, N
> one, None]>]

Hmm, here you do an execute() whereas in the first one you do a
fetchall(). Can you show the entire script?

> now, what are my options, is there new cx_oracle compiled to work with
> python 2.7 and oracle client 10.1?
> or in  previous versions of cx_oracle fetching data was completed in any
> other way than in recent verions and i'm doing sth wrong?

Perhaps. I know in newer versions of cx_Oracle you can do this:

for row in cursor.execute(some_query)

but in previous releases you had to do this:

cursor.execute(some_query)
for row in cursor

Hope that helps at least a little!

Anthony