Re: [cx-oracle-users] Full version info of cx_Oracle installed

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

On Thu, Apr 28, 2011 at 9:47 PM, Robert <web...@gm...> wrote:
> Oracle Server: 11g
> Client@Win7 : Instant Client 10g
> Python: v  2.7
>
>>>> cx_Oracle.clientversion()
> (10, 2, 0, 5, 0)
>>>> cx_Oracle.buildtime
> 'Mar 19 2011 23:12:21'
>>>> cx_Oracle.apilevel
> '2.0'
>
> Got this error:
>
>>>> db = cx_Oracle.connect(OraUid + "/" + OraPwd + "@" + OraService)
> Traceback (most recent call last):
>  File "<stdin>", line 1, in <module>
> cx_Oracle.DatabaseError: ORA-24315: illegal attribute type

This is because you are using cx_Oracle compiled against 11g but
actually using cx_Oracle against 10g. You can't do that!

> I think it is because I installed the 11g version of cx_Oracle
> (cx_Oracle-5.1-11g.win32-py2.7.msi)

Yes.

> so 2 questions:
> 1) How to verify the exact version/edition of cx_Oracle installed ?

cx_Oracle.version

That will tell you the version of cx_Oracle. It might be useful to
also include whether it is 10g, 11g, etc. as well.

> 2)  Can I just install this : cx_Oracle-5.1-10g.win32-py2.7.msi  or
> should I uninstall the existing version ?

Uninstall the original version first. The MSI packages are independent
of each other.

Anthony