How to access the Oracle9i?

Bill boober95 at rogers.com
Fri Mar 5 00:02:54 EST 2004


I heard good things about the cx package since I was looking at the same 
stuff recently.  Note you will need to install the Oracle client for this.

If you are doing just a few simple queries you can do without cx and the 
client by calling 'sqlplus' and just sending the input and capturing the 
output.  I had this working using 'popen2' and running sqlplus as a child.

This is viable if you are happy calling sqlplus each time, ie could you do 
what you want as a shell script, but it is worth considering.

/bill


Oleg Popov wrote:

> On 1 Mar 2004 21:33:45 -0800
> slackgg at 163.com (slackgg at 163.com) wrote:
> 
>> HI:
>>   above title..
> Try cx_Oracle.
> I think it is the best variant on Linux,win32 and Solaris.
> "cx_Oracle is a Python extension module that allows access to Oracle
> databases and conforms to the Python database API specification. This
> module is currently built against Oracle 8.1.7 and 9.2.0. " see:
> http://starship.python.net/crew/atuining/
> 
> 
> Popov Oleg,
> Oracle DBA
> 
> popovob at samaramail.ru




More information about the Python-list mailing list