Re: Error when importing cx_Oracle module in python interpreter

783174

Hi I am new to this python and Oracle. I am also encountering the same error.
I wish to connect to a database located on another machine using python from my machine. I dont have Oracle installed on my system but it is there on that remote machine.

I am also encountering the same error.

Right now I am using Oracle SQLdeveloper to connect to that database . But I wish to do the same using a python script.

Can you please help me with this error .

I have :-

sqldeveloper-2.1.1.64.45
python :- 2.6.5

Thanks,
Shantanu

Error which I encounter :-

import cx_Oracle

Traceback (most recent call last):
File "<pyshell#1>", line 1, in <module>
import cx_Oracle
ImportError: DLL load failed: The specified procedure could not be found.

Christopher Jones-Oracle

You will need C-language based Oracle "client" libraries installed on your local machine. (SQL Developer uses Java libraries). To connect to a remote database you can install the Oracle Instant Client from http://www.oracle.com/technology/tech/oci/instantclient/index.html Download and unzip the Instant Client "basic" package, add the directory to your PATH environment variable, reboot and run your script again.

Fahd.Mirza

You have to install the Oracle client software on your machine.

regards