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?

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.

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

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.