By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,818 Members | 1,282 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,818 IT Pros & Developers. It's quick & easy.

announce: OraPIG (python wrappers for Oracle)

P: n/a
mh
I'm pleased to announce the initial release of OraPIG,
the Oracle Python Interface Generator.

OraPIG generates Python wrapper classes for Oracle packages.

If you use Oracle and Python, this might be a pretty useful
package for you. Download it and let us know what
you think!

Cheers,
Mark

Download and docs: http://code.google.com/p/orapig

----------------

Quick Example: Suppose you have a package called tiny
with a single procedure p:

create or replace package tiny
as
procedure p(x in number);
end tiny;

OraPIG will generate a wrapper class that will allow you to
use the package without having to use the various database
calls. Instead, the wrapper class will be instantiated and
called just like any other Python class:

class Tiny:
def __init__(self,curs): # instantiate class with a cursor
...
def p(self,x): # call procedure p(x)
...

Here's how it's used:

import cx_Oracle
import tiny
conn = cx_Oracle.connect('scott/tiger')
curs = conn.cursor()

mytiny = tiny.Tiny(curs)
mytiny.p(2) # call a procedure
curs.commit() # not done automatically

--
Mark Harrison
Pixar Animation Studios
Jun 27 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.