Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Python Conneciton to Oracle DB

760226Mar 30 2010 — edited Jul 5 2010
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?

Comments

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.
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 2 2010
Added on Mar 30 2010
#python
3 comments
5,992 views