This discussion is archived
3 Replies Latest reply: Jul 5, 2010 8:27 PM by 783174 RSS

Python Conneciton to Oracle DB

760226 Newbie
Currently Being Moderated
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?
  • 1. Re: Python Conneciton to Oracle DB
    390020 Newbie
    Currently Being Moderated
    AFAIK you need -at least- the oracle instant client. Which is considerably smaller than the Oracle client, BTW. Hope somebody can probe me wrong.
  • 2. Re: Python Conneciton to Oracle DB
    604934 Oracle ACE Director
    Currently Being Moderated
    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
  • 3. Re: Python Conneciton to Oracle DB
    783174 Newbie
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points