Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Do any versions of cx_Oracle work with oracle 10.1?

700084May 6 2009 — edited May 8 2009
Hey everyone,
I'm having problems using Python 2.5 to connect with an Oracle 10g (version 10.1.0.3.0). I should mention that I'm on Windows XP.

I started out using the 10g version of cx_Oracle, but I was getting an "OCIClientVersion" error when trying to "import cx_Oracle" from the python interpreter.

Then based, on the advice here (http://osdir.com/ml/python.db.cx-oracle/2008-06/msg00023.html), I switched to version 9i of cx_Oracle.

Now I'm getting the following error:

The procedure entry point OCINlsCharSetIdToName could not be located in the dynamic link library OCI.dll

Am I simply out of luck because I have a "limbo" version of Oracle (i.e. 10.1), or is there some way to fix this error and get things working?

As an aside, my Windows PATH does point to the Oracle DLLs (C:\Ora9i\bin).
If it helps, python is installed at C:\Program Files\Python25

Can anyone suggest a fix? I'd be indebted.

Regards,
Serdar

Comments

103122
Have you tried setting LD_LIBRARY_PATH=%ORACLE_HOME%/Lib ? I don't know if it will work, but it's a good first thing to try.
1 person found this helpful
On Windows the variable would be PATH
789319
thanks for the reply i tried but it didn't work




pavanbabu g.s
Fahd.Mirza
Hi,
Please make sure that you have full rights and logged in as administrator user. Also check that in the PATH environment variable in Windows, the above mentioned path is included at the front.

regards
862974
I met this issue too and I fixed it.
The issue is that there were several copy of "OCI.dll" exist in different plance and they belong to different Oracle version. I remove the other version's OCI and the app works fine.
Also I use the following setup.py

from distutils.core import setup
import py2exe, sys

sys.argv.append('py2exe')

setup(
options = {'py2exe': {
'bundle_files': 2,
'compressed': True,
'dll_excludes': ["oci.dll"]
}},
console = [{'script': "test.py"}],
zipfile = None
)
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 5 2009
Added on May 6 2009
#python
1 comment
6,120 views