From: jefftc at leland.Stanford.EDU (Jeffrey Chang)
Date: Fri, 30 Apr 1999 00:50:00 -0700
Subject: Oracle Call Interface
In-Reply-To: <7gb3hn$lse$1@nnrp1.dejanews.com>
References: <7gb3hn$lse$1@nnrp1.dejanews.com>
Message-ID: <Pine.GSO.3.96.990430003346.3541A-100000@saga1.Stanford.EDU>
X-UID: 84                                                  

> If anyone has experience writing applications directly to the Oracle Call
> Interface (OCI), in Python or JPython please send me examples or references on
> how to do it.

Yuck!  What are you planning to do?  Do you really really need to write
directly to the OCI or can you use one of the available Oracle extension
modules? 

About a year ago, I used the oracledb module from Digital Creations with
Oracle7.  It's very nice, but not optimized, and thus slow for large
queries.  Since then, Digital Creations has made DCOracle
(http://www.digicool.com/DCOracle/; their commercial extension module) 
open source, so I guess that will replace oracledb.  I haven't looked at
it, but according to the FAQ, it's "much faster."

I strongly advise you to use an extension module or JDBC if at all
possible.  Writing to the OCI is extremely ugly -- all the stuff we try to
avoid by using python! 

Jeff