Forum Stats

  • 3,735,092 Users
  • 2,247,105 Discussions
  • 7,857,682 Comments

Discussions

Re: Error when importing cx_Oracle module in python interpreter

783174
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 :-

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.

Comments

  • Christopher Jones-Oracle
    Christopher Jones-Oracle Member Posts: 1,630 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 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
    Fahd.Mirza Member Posts: 2,984 Bronze Trophy
    You have to install the Oracle client software on your machine.

    regards
This discussion has been closed.