Forum Stats

  • 3,853,805 Users
  • 2,264,277 Discussions


Re: Error when importing cx_Oracle module in python interpreter

783174 Member Posts: 3
edited Aug 17, 2010 8:32AM in Python
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 :-

python :- 2.6.5


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
    Christopher Jones-Oracle Member Posts: 1,654 Employee
    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 Download and unzip the Instant Client "basic" package, add the directory to your PATH environment variable, reboot and run your script again.
  • Fahd.Mirza
    Fahd.Mirza Member Posts: 2,984 Bronze Trophy
    You have to install the Oracle client software on your machine.

This discussion has been closed.