Hmm, sounds like maybe you have the wrong module? When you built
cx_Oracle there is no way it would have linked properly without the
libclntsh.so.9.0 shared library. You want to make sure that when it
links it links against the Oracle 10g client library.
On your other issue, this piece of information may (or may not) help.
From Python 2.4 onwards, the type of date returned by cx_Oracle is
datetime.datetime whereas before Python 2.4 it returned
cx_Oracle.Timestamp. Did you switch Python versions at the same time?
On 2/22/06, Hubert B Hickman <hhi...@un...> wrote:
>
> I have compiled cx_oracle 4.1.2 for Solaris 8 using the Oracle 10g instan=
t
> client. I had to do a bit of changing in the setup.py file to specify th=
e
> correct include and library paths.
>
> When I try to connect to an Oracle 9i database, I get the following error=
:
>
> File
> "/export/home0/hhickman_testing/work/ResultsByOrder/ResultsDb.py",
> line 9, in ?
> import cx_Oracle
> ImportError: ld.so.1: python: fatal: libclntsh.so.9.0: open failed: No su=
ch
> file or directory
>
> If I do a symbolic link to link the 10.0 libclntsh to the 9.0 version, th=
en
> my program (mostly) works, but I eventually get to the following problem.
> TypeError: can't compare datetime.datetime to cx_Oracle.Timestamp
>
> This same program works
> I can download and install the correct 9i client and build cx_Oracle that
> way, but it would be nice to get this going with the instant client!
>
> Thanks!
>
> Hubert B. Hickman
>
> Email : hhi...@un...
|
