3 Replies Latest reply on Jul 6, 2010 3:27 AM by 783174

    Python Conneciton to Oracle DB


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

            Husnu Sensoy
            • 3. Re: Python Conneciton to Oracle DB
              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.