Forum Stats

  • 3,735,079 Users
  • 2,247,100 Discussions
  • 7,857,672 Comments

Discussions

Python Conneciton to Oracle DB

760226
760226 Member Posts: 1
edited Jul 5, 2010 11:27PM in Python
Hello.

Is there a way to connect to an oracle database without installing a separate oracle client and
without making special client settings?
A few postings below, somebody posted that there is a way to copy only some files from the oracle client
to make the connection work (for example via cx_Oracle)
Does anybody know?

Answers

  • 390020
    390020 Member Posts: 446
    AFAIK you need -at least- the oracle instant client. Which is considerably smaller than the Oracle client, BTW. Hope somebody can probe me wrong.
  • 604934
    604934 Member Posts: 86
    It is correct that you will need some so libraries for cx_oracle to work. So you need an Oracle database home, client home or at least instant client home to have those libraries.

    Regards,
    Husnu Sensoy
  • 783174
    783174 Member Posts: 3
    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.
This discussion has been closed.