3 Replies Latest reply: Jul 5, 2010 10:27 PM by 783174 RSS

    Python Conneciton to Oracle DB

    760226
      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
          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
            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
              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.