Wednesday 22 April 2009

Python and Oracle Integration

cx_Oracle is a Python Database API 2.0-compliant extension module to connect to Oracle databases. Basics of Python Database API 2.0:

connect( parameters ) - returns a Connection object
Cursor objects - manage the context of a fetch operation
TPC - two phase commits (TPC should not be confused with two phase locking). TPC relates to distributed transaction management.