[DB-SIG] DCOracle

Eric Brunson brunson@level3.net
Thu, 23 Dec 1999 11:31:48 -0700

I've just started using DCOracle, and I'm *fairly* new to python, been
using it on and off for about 4 months, but I'm having some problems
with DCOracle and I haven't found many resources on the web for docs
or code examples.

I'm using version 1.3.0 of the DCOracle module and I'm trying to use 
the Handle object.  Perhaps I'm misunderstanding the usage, but I
inferred from the description that it's usage was kinda like pre-
compiling a regex that you're going to use over and over.  I.e.

dbHndl = dbConn.prepare( "select somefield 
                         "from sometable "
                         "where thekey = :p1" )
for key in keys
    dbHndl.execute( (key,) )
    values = dbHndl.fetchone()
    <use the values then iterate>

Am I off base here?  In any case, when I try to do this, the first time
through the loop it works, but the second time, I get a NameError on 

That's my most important problem...

A more minor annoyance is that I cannot seem to find where the
exception is defined.  I want to be able to catch the specific exception
then parse the Oracle error string, but the only way I've been able to
catch it is with a default except: clause.  Sys.exc_type is set to 
OracleError but trying to catch OracleError, DCOracle.OracleError,
DCOracle.dbiUtil.OracleError, etc. all miss it.

And finally, any pointers to code examples, especially ones using some
of the more esotheric features of the module, would be appreciated.


I'm still waiting for my subscription to the list to become active,
so could any responses be copied to this return address.  Thanks again.

Eric Brunson                * _ o  *
brunson@brunson.com        * / //\         Faster and faster,
brunson@l3.net                \>>|   *       until the thrill of speed
                               \\,             overcomes the fear of