I am having a problem with cx_Oracle module for Python:
I have multiple Oracle Clients installed. I am only interested in accessing the 10g with Python.
I'm running Python 2.7.2 (python-2.7.2.msi)
I've installed cx_Oracle for Python 2.7 and Oracle 10g (cx_Oracle-5.1.1-10g.win32-py2.7.msi)
I thought placing the 10g path at the front of the PATH would fix my problem.
My last check is to verify the %PATH% environment setting is changed via Control Panel > System > Advanced system settings... curses my company has me locked out!!!
Traceback (most recent call last):
File "<pyshell#1>", line 1, in <module>
ImportError: DLL load failed: The specified procedure could not be found.
Not experienced with the windows implementation, only on linux ... but maybe it may help ...
cx_Oracle is only the bridge between python and the oci interfaces of Oracle, an exposure of the c-api's towards python.
On linux you must set the LD_LIBRARY_PATH variable to the location where the oracle client libraries can be found. (typically something linke libclntsh.so.*). So ... I guess that on a windows environment the client dll's should be in the path (%PATH%) ... Hope somebody can confirm or correct this. Maybe it may help ...