[DB-SIG] Re: [FRPythoneers] Oracle ODBC
Rob Riggs
rob@pangalactic.org
Mon, 17 Jun 2002 10:18:54 -0600
Bob Gailer wrote:
> I am programming in Python (via IDLE and PythonWin) on a Win NT4 box,
> accessing Oracle 8i database on Solaris 2.8 via Oracle's ODBC driver.
>
> I am having good success running pl/sql through this interface; what
> I'd like to do is to get a value back from the pl/sql into Python. Any
> ideas?
>
> Bob Gailer
> mailto:ramrom@earthling.net
> 303 442 2625
>
I'm not sure how to do this via ODBC. (I've never done it.) However, you
can do this with DCOracle2, a Python DB API 2.0 compliant database
adapter from Digital Creations. You do this by either using
cursor.callproc() or the cursor.procedure object.
http://www.zope.org/Members/matt/dco2
-Rob